Discussion Board for collaboration on QlikView Scripting.
I have a string column in a table with ; as delimiter but number of parts are not fixed it can be 1 or 5 or 100.
Any idea how can I split the string and create separate records from it at load time.
LongString, // LongString have values like "ABC;DEF;HIJ;KLM" OR "XYZ;OPR;LMJ" OR "PPP;SSS"
Go to Solution.
LOAD ID, SubField(LongString, ';') AS FieldNameRESIDENT OldTab;
Hope that helps.
It worked very well...never knew I could use subfield without field_no parameter.