topic Re: DSR Test in QlikView

DSR Test

Anonymous — Wed, 22 Oct 2014 11:10:50 GMT

Hi All

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

Thanks ,

Re: DSR Test

Gysbert_Wassenaar — Wed, 22 Oct 2014 11:38:00 GMT

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

Re: DSR Test

Anonymous — Wed, 22 Oct 2014 13:25:56 GMT

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)),

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

Remove(Row, Pos(Top, 58)

));

Re: DSR Test

Gysbert_Wassenaar — Wed, 22 Oct 2014 13:49:38 GMT

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.