How do I STORE data from Excel?

[Paknanarn23]

I would like to bother I would like to STORE the data from Excel that I retrieve daily I have tried it When I retrieve the data everyday Qlikview synthesizes the data so some of the required data are not displayed What should I do?

this is my code

Please help me. Thank you very much.

[Oleg_Troyansky · Accepted solution]

Hi there,

It looks like the data format in your various Excel tables can be changing over time - hence the several tables with synthetic keys between them. You need to CONCATENATE these tables into one, to force all of them into the same format. Something along these lines:

// Generate a dummy table as a starter:

PP_CONFIRM:

LOAD

   1 as Dummy

Autogenerate(1)

;

// Concatenate all data tables into the same table:

Concatenate (PP_Confirm)

LOAD * 

FROM ..... *.xlsx ....

Drop field Dummy;

This should do the job.