Python Script

jose_magrinhojose_magrinho Posts: 3 New member
edited July 16, 2019 10:35AM in SQL Data Generator
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 '/, +, *' ...


Tagged:

Best Answer

  • Alex BAlex B Posts: 800 Diamond 2
    Accepted Answer
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?

Answers

Sign In or Register to comment.