Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Connect mysql

Good evening,

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

Is it possible?

 

Best regards

Labels (1)
5 Replies
Highlighted
Creator II
Creator II

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.

Highlighted
Contributor II
Contributor II

How can I use different table name?
Highlighted
Creator II
Creator II

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?

 

Highlighted

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

Highlighted
Contributor II
Contributor II

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

Best regards