Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to convert the following columns vertically as Branch
0854 - GXWFI | 0855 - GXOAS | 0857 - GXBU1 | 0859 - GXGAZ | 0860 - GXFRA | 0861 - GXHDB | 0862 - GXPLD | 0863 - GXNHD | 0864 - GXHMN | 0865 - GXMAC | 0866 - GXARM | 0868 - GXTCM | 0869 - GXFRD | 0870 - GXNTT | 0872 - GXUAQ | 0873 - GXMZY | 0874 - GXBRJ | 0877 - GXQOZ | 0878 - GXDIA |
and following columns vertically as hypermarket
Ajman | Deira | Al Saqr ADH | RAK Manar | Marina Mall | Jimmy Mall | Sharjah | Shindaga | Century Mall | Mall of Emirates | Al Ain Bawadi | RAK Zaith 2 | Dalma Store AUH | Mirdiff | Baniyas | Fuj Cent Mall |
pls find the attached excel.
Regards,
Joshua
Try this? PFA
USE JOIN for 2 cross tables?
Dear Anil,
I am getting this error
Regards,
Joshua.
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
Table1:
CrossTable(Branch, Data, 20)
LOAD
...
...
//When create this table select only Hypermarket columns
Table2:
CrossTable(hypermarket, Data, 20)
LOAD
...
...
May be remove JOIN and check
After loading this tables use resident load of the tables.
Table1:
CrossTable(Branch, Data, 20)
LOAD
...
...
//When create this table select only Hypermarket columns
Table2:
CrossTable(hypermarket, Data, 20)
LOAD
...
...
///////////////////////////
Noconcatenate
Final:
Load * , 'Branch Table' as TableFlag Resident Table1;
Concatenate(Final)
Load * , 'Hypermarket Table' as TableFlag Resident Table2;
Drop Tables Table1,Table2;
Dear Anil,
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
Regards,
Joshua.
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
Dear Anil,
Yes bro but the columns still exists.
Regards,
Joshua.
Try this?