Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Arjunarao
Honored Contributor II

Dynamic data load with titles names

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]);

Tags (2)
1 Solution

Accepted Solutions

Re: Dynamic data load with titles names

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

4 Replies
balrajahlawat
Esteemed Contributor

Re: Dynamic data load with titles names

You can do like this?

Check the attachment

Re: Dynamic data load with titles names

Hi,

Check the attachment.

Re: Dynamic data load with titles names

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

MVP
MVP

Re: Dynamic data load with titles names

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

Community Browser