Discussion Board for collaboration on QlikView Scripting.
i got requirement which the data in text file with delimiters(:,|) i removed in Delimiter and using subfield but i am not desired output
i attached the code and required output file image
I'm not sure that I understand all but you can begin with this, I hope this can help you.
Try this script
LOAD @1 as id,
@2 as product,
@3 as productwithprice
[my script .txt]
(txt, codepage is 1252, no labels, delimiter is ':', msq, header is 2 lines);
SubField(product, '|') AS Product
SubField(productwithprice, '|') AS Productwithprice
DROP TABLE Temp;
Hope this helps you.
Please post your data file
I think you can achieve the same result in a a single step:
SubField(product,'|' ) as product,
SubField(productWithPrice,'|' ) as productWithPrice
(txt, codepage is 1252, embedded labels, delimiter is ':', msq);
i did like this but in the end if i am taking a table box i can see some repeated data in the productwithprice table
so the result is mismatching ....