topic Re: How to seperate one table to two sames table? in App Development

How to seperate one table to two sames table?

Anonymous — Wed, 14 Mar 2018 03:33:22 GMT

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);

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

jwjackso — Sat, 17 Mar 2018 15:35:22 GMT

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;

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

swuehl — Sat, 17 Mar 2018 15:49:21 GMT

Maybe use the QUALIFY *; statement?

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

VishalWaghole — Sat, 17 Mar 2018 15:53:03 GMT

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.

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

katharinakostka — Sat, 17 Mar 2018 17:26:40 GMT

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

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

Anonymous — Fri, 06 Apr 2018 06:05:37 GMT

Thanks

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

Anonymous — Fri, 06 Apr 2018 06:06:18 GMT

Thanks

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

Anonymous — Fri, 06 Apr 2018 06:07:28 GMT

Thank you very much for your answer!