Python Script
jose_magrinho
Posts: 3 New member
Hi,
So, I've been generating some data using Python Scripts but i only manage to use the data from other columns in the same table.
Is it possible to use data from other columns that are not in the same table? I want to try some basic operators between them, like '/, +, *' ...
So, I've been generating some data using Python Scripts but i only manage to use the data from other columns in the same table.
Is it possible to use data from other columns that are not in the same table? I want to try some basic operators between them, like '/, +, *' ...
Tagged:
Best Answer
-
Alex B
Posts: 1,158 Diamond 4
Hi @jose_magrinho,
There is only the columns available within the table you are working with as the column name values are in the dictionary provided to the main function (see this page).
You would need to connect to the SQL Server in the python script and query the other table or as you have seen, use the SQL Statement generic generator.
Kind regards,
Alex
Answers