How can we help you today? How can we help you today?

Python Script

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 '/, +, *' ...


jose_magrinho
0

Comments

2 comments

Sort by
  • jose_magrinho
    I managed to do it with the SQL Statement, but i wanted to do something similar to an if/else structure with select commands. Is it possible?
    jose_magrinho
    0
  • Alex B
    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
    Alex B
    0

Add comment

Please sign in to leave a comment.