Split single row with multiple line into different columns
I have source data which Excel spreadsheet , there are some records which have multiple entries. So I am trying to split the records into multiple columns so that I can use them in my expression calculations. So when I import them into QlikView, its just one line.
I have highlighted these records in yellow in the attached.
Hi Zwyne, Do you want to split the records to multiple columns? or multiple rows? if columns, what's the column name for every value? if rows, I think you can use the subfield() function, but you need to make the rules,like for column C, the rule may be Line Feed for column D, the rule may be "and" for column E, the rule may be "," Aiolos Zhao