Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

qlikyulei
New Contributor

How to seperate one table to two sames table?

There are no connection and no concatenation between two same tables.

How to do this ?  Please give me some suggestion.

tab1:

LOAD [col1],

[col2],

[col3],

[amount]

FROM [lib://C/New Microsoft Excel Worksheet.xlsx]

(ooxml, embedded labels, table is Sheet1);

tab2:

LOAD [col1],

[col2],

[col3],

[amount]

FROM [lib://C/New Microsoft Excel Worksheet.xlsx]

(ooxml, embedded labels, table is Sheet1);

1 Solution

Accepted Solutions
MVP
MVP

Re: How to seperate one table to two sames table?

Maybe use the QUALIFY *; statement?

7 Replies
jwjackso
Contributor III

Re: How to seperate one table to two sames table?

tab1:

LOAD [col1],

[col2],

[col3],

[amount]

FROM [lib://C/New Microsoft Excel Worksheet.xlsx]

(ooxml, embedded labels, table is Sheet1);

NOConcatenate

tab2:

load *

Resident tab1;

MVP
MVP

Re: How to seperate one table to two sames table?

Maybe use the QUALIFY *; statement?

vishalwaghole
Valued Contributor II

Re: How to seperate one table to two sames table?

tab1:

LOAD [col1],

[col2],

[col3],

[amount]

FROM [lib://C/New Microsoft Excel Worksheet.xlsx]

(ooxml, embedded labels, table is Sheet1);

QUALIFY *;

tab2:

LOAD [col1],

[col2],

[col3],

[amount]

FROM [lib://C/New Microsoft Excel Worksheet.xlsx]

(ooxml, embedded labels, table is Sheet1);

Note : NoConcatenate will create synthetic key.

katharinakostka
New Contributor III

Re: How to seperate one table to two sames table?

Hi!

Well as you see, same fields usually create an autoconcatenate. Even if you prevent it via a NOCONCATENATE before the second LOAD statement, you still get -as pointed out by vishal- a synthetic key.

Your question was, how to load it without connecting it, so therefor without synthetic key... as Stefan already mentioned you can archieve this via qualify which will lead to an automated renaming of the fields that keeps the tables separated... Or you could also rename the fields manually. Your choice.

Regards Katharina

qlikyulei
New Contributor

Re: How to seperate one table to two sames table?

Thanks

qlikyulei
New Contributor

Re: How to seperate one table to two sames table?

Thanks

qlikyulei
New Contributor

Re: How to seperate one table to two sames table?

Thank you very much for your answer!

Community Browser