How to change bellow Scenario

[kulasekhar]

Hi All,

Scenario:  Product in one column, different dates in different columns

Data : provided in attached excel file.

Product	12-Apr	13-Apr	14-Apr	15-Apr
P1	100	200	200	700
P2	200	100	300	100
P3	300	300	400	300
P4	400	400	500	400
P5	500	600	600	600
P6	600	700	700	400
P7	700	100	100	500

Result should display as   :

Date |Product1 | PRoduct2 | Product3 | ....| in  a table 

Thanks,

Thimma

[PrashantSangle]

Hi,

Do you want in script???

If yes do transpose while loading data. in Enable Loading Transformation step->Rotate

Regards

[nagarjuna_kotha]

Hi,

Use Transpose when u r loading .

Regards,

Nagarjuna

[Marcellino_Groothof]

Hi,

Read the table file, header size = lines, then push button NEXT, then transpose.

Greetings,

Marcellino

[ganeshreddy]

Hi Shekhar,

Do following steps,

1. while loading select enable transformation

2. select rotate.

3 .apply transpose and the press right.

you will get your desired result.

Cheers,

Ganesh

[jonathandienst]

Hi

You need a cross table load to get the dates and product names as fields:

Temp:

CrossTable(Date, Amount, 1)

LOAD * FROM ....xls;

Final:

LOAD Product,

  Date(Date#(Date, 'dd-mmm')) As Date,  // gets date as a numeric QV date

  Amount

Resident Temp;

DROP Table Temp;

Then create a straight table with Date and Product as dimensions and Sum(Amount) as the expression

HTH

Jonathan

[kulasekhar]

Thanks for ever one. giving solution.

Thanks

sekhar

[buzzy996]

pfa,hopes this also helps just created using cross table.