Discussion board where members can get started with QlikView.
i have text file like this
item 2 200 etc
i wold like have restult :
16/02/2018 item1 100
16/02/2018 item2 200
how can i do?
You can use below script to achieve to the desired result:
LOAD @1 as OG_Data
(txt, codepage is 1252, no labels, delimiter is '\t', msq);
left(OG_Data,7) as Item,
KeepChar(mid(OG_Data,7),'0123456789') as Value
,Peek(OG_Data,0,'Data') as Date
DROP Table Data;
View solution in original post