Script to transform Exceltable with slow moving categories

[Anonymous]

Hi

I have a inputtable in excel with categories and then datarows below. On each datarow I would like to know the category that the datarow belongs to. Se the pictures as sample input. I also attach a small samplefile in excel. How can I make the resulttable with script in Qlikview. Any ideas?

Best regards

Peter

[Gysbert_Wassenaar · Accepted solution]

Perhaps like this:

Data:
LOAD *
WHERE Qty <> 'Qty' ;
LOAD
  If(Previous(B)='Qty' ,Previous(A),Peek(Category)) as Category,
  A as Item,
  B as Qty,
  C as Value
FROM
[Sample_data.xlsx]
(ooxml, no labels, table is Input)
WHERE Len(Trim(B))>0;

[Anonymous]

It's wokring. Thank you Gysbert for the help