topic Re: Dynamic data load with titles names in QlikView

Dynamic data load with titles names

qlikviewwizard — Tue, 01 Mar 2016 07:51:38 GMT

Hi All,

I want to load the data dynamically from the files likes Sales Data - 2015.xlsx,Sales Data - 2016.xlsx.

Need to load the first sheet name is like Sales Data - 2015,Sales Data - 2016.

Last two columns in the files are with Year names like Sales 2015,Sales 2016.

Please check the attached file.

I want to do like this but not sure how to achieve .

Sales:

LOAD ColumnA as Ename,

ColumnB as Year,

ColumnC as Month,

ColumnD as Sales,

ColumnE as Target

FROM

[ExternalData\Excel\Sales Data - 2015.xlsx]

(ooxml, embedded labels, table is [Sales-2015]);

Anonymous — Tue, 01 Mar 2016 08:09:03 GMT

You can do like this?

Check the attachment

tamilarasu — Tue, 01 Mar 2016 08:20:24 GMT

Hi,

Check the attachment.

MayilVahanan — Tue, 01 Mar 2016 08:20:51 GMT

Are you looking like this

Sales:

LOAD A as Ename, B as Year, C as Month, D as Sales, E as Target FROM

[Sales Data - *.xlsx]

(ooxml, no labels)

Where B <> 'Year';

jagan — Tue, 01 Mar 2016 08:39:43 GMT

Hi,

In addition to this you can add FileName() for reference, it helps while testing.

Sales:

LOAD A as Ename, B as Year, C as Month, D as Sales, E as Target,

FileName() AS FileName

FROM

[Sales Data - *.xlsx]

(ooxml, no labels)

Where B <> 'Year';