Getting data from other table?

shnek

I know you can easly access data from another column in the same table, but is there a way, for example using python script where I can access data from a specyfic column in another table?

Alex B

Hi Schnek,

You can use the Generic > SQL Statement generator to get data from a column in a different table that is being generated. So if you have column one in table1 and column two in table2 (both int for instance), if you use the SQL Statement generator for column two in table2 and have the following query:

SELECT one
FROM table1

Then both column one in table1 and column two in table2 will have the same data (ensure you uncheck Shuffle data). You could probably do something similar with IronPython in the script generator as well.

Kind regards,
Alex