What are the challenges you face when working across database platforms? Take the survey

Python Script

jose_magrinhojose_magrinho Posts: 3 New member
edited July 16, 2019 10:35AM in SQL Data Generator

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


Best Answer

  • Options
    Alex BAlex B Posts: 1,146 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,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.