Transpose a physical table

[#1]

Hi All,

I have a physical table with the following structure:

ID_CLIENT     Date                Cost1     Cost2     Cost3     Cost4

1                    20/12/2013       2               3          1            1

2                    20/12/2013       1               1           1           1

I want to transpose in this table in qlikview:

ID_Client        Date                  cost          Amount

1                   20/12/2013          Cost1          2

1                   20/12/2013          Cost2          3

1                   20/12/2013          Cost3          1

1                   20/12/2013          Cost4          1

2                   20/12/2013          Cost1          1

2                   20/12/2013          Cost2          1

2                   20/12/2013          Cost3          1

2                   20/12/2013          Cost4          1

How should I go about it?

Thanks,

PP

[Peter_Cammaert]

Use a LOAD prefix called CROSSTABLE. Very powerful. There is a wizard for this in the Script Editor. See QlikView help for further information.

Peter

[tresesco]

Try like:

Crosstable( Cost, Amount, 2) Load * From <>;

[Peter_Cammaert]

See this document

Peter

[jagan]

Hi,

Try this script using Crosstable()

Data:

CrossTable(CostNo, Cost, 2)

LOAD * INLINE [  

    ID_CLIENT,     Date,                Cost1,     Cost2,     Cost3,     Cost4

1,                    20/12/2013,       2,               3,          1,            1

2,                    20/12/2013 ,      1,               1,           1,           1

];

Regards,

Jagan.

[#6]

Thanks!