I have a stock movement report in csv format in following layout.
The problem is the header in line 2 which contains the Item Code and Description for the movements shown (in cells.A2 and B2)
If I load as shown, there will be no assocaition between the Item and the movement data.
This layout repeats for each item on the stock movement file.
I want the data to load as follows:
Excellent! Works great.
I understand most of the solution, but I am unsure of the role of Concatenate/Noconcatenate, even though I know it is a fundamental element of Qlikview.