Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
Maybe use the QUALIFY *; statement?
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;
Maybe use the QUALIFY *; statement?
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.
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
Thanks
Thanks
Thank you very much for your answer!