Discussion Board for collaboration related to QlikView App Development.
I have data in TXT FILE . It contains two field OBJECT AND VALUES. The Values field is always comma delimited as seen below in Current Structure.
I would like to change the table structure as shown in desired structure.
Can someone please help me how to achieve this during load??
Go to Solution.
Hi, you can use iterno() to run to a single line many times.
You can use subfield to retrieve part of the string separeted by the commas:
LOAD * INLINE [
lOAD OBJECT, SubField(VALUE,',',ITERNO()) AS VALUE_RESULT
DROP TABLE TABLE;
Hope this helps,
Can u give me any sample file ...
with this function: subfield( your fieldOBJECT ,',')
trim(subfield([Values],';')) AS [Project Ref. ProjectId TEMP]
Erich is correct, Subfield will do the job for you. But Iterno() function is not mandatory. If you use subfield at back end with out any third parameter will loop through the field.
TABLE:LOAD *, SUBFIELD(VALUE,',') AS NEWVAULE;LOAD * INLINE [ OBJECT, VALUE A, "123,456" B, 1234 C, "136,1532,16323"];
Hope this may help you.
Thank you all for the quick reponse!!
Erich, Thank you for the solution. Worked perfectly!!
Your post was very help full thanks.