how to load the sheet object into qv appl

[Anonymous]

HI

can any one explain the excel file contain two sheets in that each sheet has same columns name with different values dont load sepertly with out concatinate brin the data int qlik view application.

[rwunderlich · Accepted solution]

If two loads have exactly the same column names QV will automatically concatenate them into the same table. You can override this behavior by adding the NOCONCAENATE prefix to the LOAD.

-Rob

[Anonymous]

Hi Rob

thanks for reply.is it posible to load with out concatinate.

[prieper]

Hi,

then add a dummyfield or insert one more field with FILENAME() or the like in order to differentiate, from which file a certain information came.

HTH
Peter

[Anonymous]

HI thanks for reply Peter.

>>can you sent me the simple appl, where we need to add the field.

[prieper]

Hi,

very simple version might be

LOAD
*;
FILENAME() AS File
FROM MyExcelFile*.xls (biff, embedded labels, table is Sheet1$);

This would load all files starting with "MyExcelFile" .

HTH
Peter

[rwunderlich]

arunreddy wrote:thanks for reply.is it posible to load with out concatinate

Yes. Use the NOCONCATENATE prefix.

Table1:
LOAD F1, F2
FROM file1;

Table2:
NOCONCATENATE LOAD F1, F2
FROM file;

The NOCONCATENATE prefix will force Table2 to be created as a seperate table, even though both tables have the same field.

-Rob