Cross table

[ajsjoshua]

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

[Anil_Babu_Samineni]

Try this? PFA

USE JOIN for 2 cross tables?

[ajsjoshua]

Dear Anil,

I am getting this error

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

[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]

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.

[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

[ajsjoshua]

Dear Anil,

Yes bro but the columns still exists.

Regards,

Joshua.

[Anil_Babu_Samineni]

Try this?