topic same description in excel field in QlikView

same description in excel field

anat — Wed, 25 Nov 2020 16:16:04 GMT

hi ,

how to load the attached excel file data.

what i am facing the problem is ,

after loading the data if i select Total1 and a data is coming for jan 14,but what i want is separate records like

total1 and a value should be 1

total2 and a value should be 13

Gysbert_Wassenaar — Fri, 29 Apr 2016 14:40:36 GMT

Try this:

LOAD Desc,

If(WildMatch(Desc,'Total*'),Desc,peek(Total)) as Total,

jan,

feb,

mar,

apr

FROM

[test123,xlsx]

(ooxml, embedded labels, table is Sheet1)

;