Discussion board where members can get started with QlikView.
I need to load multiple data tables containing the same fields, each for a different client, example below:
Anyone know of a way when loading of adding the client name to each row of data in the table without having to go into each sheet and adding an additional 'client' column as below?
thanks in advance,
Go to Solution.
You can subscribe to the blog.
The following PDF file with the tutorial.
Just Use the Code as follows:
'AAAA' as ClientName
'BBBB' as ClientName
and so on..........
Hope this helps...
You can see in the blog community Toccato. I posted about it today. Only in Portuguese.
Thanks for the responses. Unfortunately I am unable to access the linked blog.
My initial question was a little unclear, so I will clarify what I am trying to achieve.
I have multiple spreadsheets each for a different client in the following format:
I am looking for some code that will pick up the client in cell B1 and produce a Qlikview table as follows:
Try something like this, basically just reads the top line of the spreadsheet, passes the value of col B to a variable to use in the secondary load. All the sheets will need to be same format etc..
Temp:LOAD A, //col A B, //col B C //col CFROM[Clients.xlsx](ooxml, no labels, table is Sheet1)Where rowno()=0;
DROP TABLE Temp;
Data:LOAD '$(vClient)' as Client, A as Date, B as Value, C as FeeFROM[Clients.xlsx](ooxml, no labels, header is 4 lines, table is Sheet1);
Have just followed the steps in the PDF and it does exactly what I want, much appreciated.
Will give the other method a try too.