Discussion board where members can get started with QlikView.
I need to convert the below single line of data into three.
This is my actual data.
I need to covert that into three based on Barcode column Like below
Any help would be appreciated.
SubField(Barcode,'to',1)-1+IterNo() as Barcode2
While SubField(Barcode,'to',1)-1+IterNo() <=SubField(Barcode,'to',2);
Load * Inline [
"Receiving Date", "Doc In", "Avarage package", "Batch Type", BatchID, Barcode
6/29/2016 15:32, 3, 30, Outer Package, 681633, 16005003228 to 16005003230