Data Generator List function

[ThomyKay]

Both flavors of the List function are choosing random values out of the list with multiple occurences.

What I would need is to get ALL values out of the resultset with 1 occurence (cycled by Master table value list). Background: The related table data is static system data (can't use it as master table in Data Generator context). If using List function with mulitple value occurences I would violate a unique key on the target table.

Doable?

 

[Marco Kalter]

Do you mean that you want to get more than 1 related column values from a list? This is currently only possible with a file instead of a table. For an example see the Components.txt and Elements.txt files in the DataGenerator\UserData subdirectory.

You can however create a SQL function that retrieves a value from the table and retrieves related values for subsequent calls. Use the SQL() function to call this function to get the correct values.

 

[ThomyKay]

I wanted to get all values (single column or multiple columns) from a table/SQL statement once in the target table, not randomly with multiple occurences as happended with the List function.

 

[Marco Kalter]

This is currently only possible with a file.