Cross Table with looping

[#1]

hiii i m stuck in issue whr i want 2 cross table nd then concatenate. i m attaching the dummy data along with output

[#2 · Accepted solution]

Hi Amit,

You can try the script below. For the Month, you might need to rename to Month Year if you need to link it to a calendar. Currently i just show as what they are

Retails_Tmp:

LOAD [All Models Retails] As [SR No],

     F2 As [Region],

     F3 As [Dlr Code],

     F4 As City,

     'Retail' As Type,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     July

FROM

(ooxml, embedded labels, header is 1 lines, table is Retails, filters(

Remove(Row, Pos(Top, 2))

))

WHERE Len([All Models Retails])>0;

Sales:

CrossTable(Mth, Val,5)

LOAD *

Resident Retails_Tmp;

DROP TABLE Retails_Tmp;

WS_Tmp:

LOAD [All Models Wholesale] As [SR No],

     F2 As [Region],

     F3 As [Dlr Code],

     F4 As City,

     'Wholesale' As Type,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     July

FROM

(ooxml, embedded labels, header is 1 lines, table is WS, filters(

Remove(Row, Pos(Top, 2))

));

//this will concatenate with the first Sales crosstable

CrossTable(Mth, Val,5)

LOAD *

Resident WS_Tmp;

DROP TABLE WS_Tmp;

[settu_periasamy]

May be check the Attachment.

[#4]

which attachment

[settu_periasamy]

I think you are looking via inbox. open the separte window.. or click here..

Cross Table with looping

[#6]

thnks

[#7]

could you provide me qvw of the code and also tell me how you are using this" Remove(Row, Pos(Top, 2))"

[#8]

You can just follow the File Wizard steps. Please see attached file for the step i did