How do I STORE data from Excel?

Paknanarn23 — Wed, 12 Jul 2023 03:40:30 GMT

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.

Re: How do I STORE data from Excel?

Oleg_Troyansky — Wed, 12 Jul 2023 14:32:43 GMT

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.

topic Re: How do I STORE data from Excel? in QlikView

How do I STORE data from Excel?

Re: How do I STORE data from Excel?