topic Re: Excel files Upload in QlikView

Excel files Upload

prma7799 — Mon, 30 Apr 2018 07:36:19 GMT

Hi All,

I am getting stuck here that how to upload or fetch latest new target excel file with fashion of old 17-18 excel file.

In Target 17-18 file have multiple (12 times) record for HQ_NAME in TargetDate as vertical and [TAR Val AMT] amount have addition of 12 months target .

Now kindly suggest how to extract new file (target 18-19) to existing application.

Thanks

PFA for sample file.

Re: Excel files Upload

jonathandienst — Mon, 30 Apr 2018 08:26:03 GMT

Like this:

T1:

CrossTable(TargetDate, [TAR Val AMT], 3)

LOAD *

FROM

(ooxml, embedded labels, table is Sheet1);

//*Fix Date Format

T2:

NoConcatenate

LOAD [SG ID],

[HQ ID] as HQ_ID,

HQ_NAME,

Date(Trim(TargetDate)) as TargetDate,

[TAR Val AMT]

Resident T1;

DROP Table T1;

Concatenate(T2)

LOAD [SG ID],

HQ_ID,

HQ_NAME,

[TAR Val AMT],

Date(TargetDate) as TargetDate,

[Monthly Tar Val]

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Excel files Upload

prma7799 — Mon, 30 Apr 2018 08:41:49 GMT

PFA