Cross table

[Anonymous]

Hello Everyone,

How to apply cross table function in the below data?

Regards

kulwant

[Anil_Babu_Samineni]

Instead Cross table you can apply transpose while loading.. Can you share excel file and expected result

[Anonymous]

attached

[its_anandrjs · Accepted solution]

Hi,

Load your data this way

tmpSource:

CrossTable(Dates, Data, 2)

LOAD F1,

    F2,

    [01/11],

    [02/11],

    [03/11]

FROM

Data1.xlsx

(ooxml, embedded labels, table is Sheet1);

LOAD

F1 as Area,

F2 as Range,

Dates,

Data

Resident tmpSource Where Data <> '%';

DROP Table tmpSource;

OutPut:-

[Anonymous]

thanks

[Anil_Babu_Samineni]

Here we go

[Anonymous]

Crosstable can be done directly while loading data only.

Click Table Files -> Next-> Next-> Under Prefixes select -> Crosstable-> Select Qualifier fields-> Atrribute fields (Which you want to make it straight) -> Data field

CrossTable(Account, Data)

LOAD MonthlyRegionKey,

     Account,

     ExpenseActual,

     ExpenseBudget

FROM ....

Now table will be of 3 columns

MonthlyRegionKey | Account   | Data

                                Account

                               Exp Actual

                               Exp Budget