Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good evening,
I would like to connect the same table 2 times from a mysql connector.
Is it possible?
Best regards
You can extract the same table from a source (e.g. MySQL) multiple times.
You either need to use different table names or just concatenate the tables such that you get duplicate rows.
Hope it helps.
You can change the table name in the script editor section. It would look something like:
TableName1:
Load
*
From SourceTable of MySQL connection;
TableName2:
Load
*
From SourceTable of MySQL connection;
Can you describe more clearly what you need?
Yes , just duplicate your select statement to the table you wanted to connect more than 1 time .