Dynamic data load with titles names

[qlikviewwizard]

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 .

Please advise. jagan mohan rao appala MAYIL VAHANAN RAMASAMY Celambarasan Adhimulam

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]

You can do like this?

Check the attachment

[tamilarasu]

Hi,

Check the attachment.

[MayilVahanan · Accepted solution]

Hi

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]

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';