Discussion Board for collaboration on QlikView Scripting.
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
LOAD ColumnA as Ename,
ColumnB as Year,
ColumnC as Month,
ColumnD as Sales,
ColumnE as Target
[ExternalData\Excel\Sales Data - 2015.xlsx]
(ooxml, embedded labels, table is [Sales-2015]);
Go to Solution.
Are you looking like this
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';
You can do like this?
Check the attachment
Check the attachment.
In addition to this you can add FileName() for reference, it helps while testing.
LOAD A as Ename, B as Year, C as Month, D as Sales, E as Target,
FileName() AS FileName