CrossTable is not enough, as far as I know. Do you know?

[nenadvukovic]

Hi,

If you have a table structured like this:

                         P1      P1      P2      P2

Customer      Volume Price Volume Price

ABC                100      10      200      11

DEF                300      20      400      21

using the CrossTable function, I can't get this:

Customer      Period     Volume Price

ABC                P1          100      10

ABC                P1          200      11

DEF                P2          300      20

DEF                P2          400      21

Thanks a lot

I get two unexpected rows and incorrect Price:

Message was edited by: Nenad Vuković

[sunny_talwar]

May be check this out

multi_header_pivot_import.qvw

[sunny_talwar]

PFA the sample script

[nenadvukovic]

Thanks Sunny. My original table has this structure:

I need first 9 dimensions to be available. Next 3 I ignore and then read values for 12 x 2 columns (Volume and Price).

Do I need to modify the provided script to handle this structure?

Thank you

[sunny_talwar]

Change here

Add all the dimensions you need.

And add all the dimension here

[nenadvukovic]

Yes, I realized that in the meantime. Thank you very much.

[nenadvukovic]

Hi Sunny,

Can you please take a look into the updated initial post as I am getting strange results. Thx

[sunny_talwar]

May be share your Excel file here for us to test

[nenadvukovic]

Thanks for looking into this.

You can find a few lines in the attached file.

[sunny_talwar]

See if this works