Discussion Board for collaboration on QlikView Scripting.
I want to convert the following columns vertically as Branch
and following columns vertically as hypermarket
pls find the attached excel.
Try this? PFA
USE JOIN for 2 cross tables?
I am getting this error
Use Cross table load with the wizard way and try this way and load the table two times
//When create this table select only Branch columns
CrossTable(Branch, Data, 20)
//When create this table select only Hypermarket columns
CrossTable(hypermarket, Data, 20)
May be remove JOIN and check
After loading this tables use resident load of the tables.
Load * , 'Branch Table' as TableFlag Resident Table1;
Load * , 'Hypermarket Table' as TableFlag Resident Table2;
Drop Tables Table1,Table2;
All hypermarkets are also coming under Branch column I want only from 0854-GXWFI to 0878-GXDIA in branch column .
In hypermarket column i want only from Ajman to Fuj Cent Mall
As i stated over end up the script, There is some Remove(Col, Pos(Top, 36)), that means i've removed all those which is unnecessary, Will you do the same while transformation
Yes bro but the columns still exists.