Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anat
Master
Master

same description in excel field

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

1 Reply
Gysbert_Wassenaar

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)

     ;


talk is cheap, supply exceeds demand