Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

Cross table

Hi all,

I want to convert the following columns vertically as Branch

0854 - GXWFI0855 - GXOAS0857 - GXBU10859 - GXGAZ0860 - GXFRA0861 - GXHDB0862 - GXPLD0863 - GXNHD0864 - GXHMN0865 - GXMAC0866 - GXARM0868 - GXTCM0869 - GXFRD0870 - GXNTT0872 - GXUAQ0873 - GXMZY0874 - GXBRJ0877 - GXQOZ0878 - GXDIA

and following columns vertically as hypermarket

AjmanDeiraAl Saqr ADHRAK ManarMarina MallJimmy MallSharjahShindagaCentury MallMall of EmiratesAl Ain BawadiRAK Zaith 2Dalma Store AUHMirdiffBaniyasFuj Cent Mall

pls find the attached excel.

Regards,

Joshua

10 Replies
Anil_Babu_Samineni

Try this? PFA

USE JOIN for 2 cross tables?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ajsjoshua
Specialist
Specialist
Author

Dear Anil,

I am getting this error

Untitled.png

Regards,

Joshua.

its_anandrjs

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

...

...

Anil_Babu_Samineni

May be remove JOIN and check

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
its_anandrjs

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;




ajsjoshua
Specialist
Specialist
Author

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

2.png

Regards,

Joshua.

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ajsjoshua
Specialist
Specialist
Author

Dear Anil,

Yes bro but the columns still exists.

Regards,

Joshua.

Anil_Babu_Samineni

Try this?

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)