Connect mysql

[Luca80]

Good evening,

I would like to connect the same table 2 times from a mysql connector.

Is it possible?

Best regards

[TimvB]

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.

[Luca80]

How can I use different table name?

[TimvB]

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?

[avinashelite]

Yes , just duplicate your select statement to the table you wanted to connect more than 1 time .

[Luca80]

Thank you so much to all for the reply.
Next days Ia will try the solution.

Best regards