DSR Test

[Anonymous]

Hi All

How to convert (DSR) file using cross table......

Thanks ,

[Gysbert_Wassenaar]

Very extremely much pain. Don't do it. Get the original sales data instead directly from the source system.

[Anonymous]

How it was done?

Means what is procedure to do this and if I remove below code then what will happen...

T1:

LOAD @1 as Category,

     @2 as Brand,

     RowNo() as Column

FROM

[comm139074.xlsx]

(ooxml, no labels, table is Sheet1, filters(

Transpose(),

Remove(Col, Pos(Top, 1)),

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 1)),

Replace(1, top, StrCnd(null)),

Remove(Row, Pos(Top, 58)

));

[Gysbert_Wassenaar]

How was it done? With quite a bit of effort.

The procedure to do this is to study hard and then apply the knowledge gained to the problem.

If you remove the code you posted then the script will not produce the needed result. Try it. Remove the code and see what happens.

What the code does is transpose the data in the excel sheet, remove the first column, the first six rand rows and the last row, fill the first column cell values if they are empty with the value of the above cell, load the first column as Category, the second as Brand and add a calculated field named Column using the RowNo() function.