topic Re: splitting single row into multiple values in QlikView

splitting single row into multiple values

Anonymous — Tue, 20 Sep 2016 10:43:56 GMT

I need to split a single row into multiple rows based on the Values present in the Name field. If there is enter in a row i.e . chr(13) the ticket needs to be shown as a separate row

Attaching a screenshot of the current vs desired table. Is it possibel to use subfield with chr(13)?

Re: splitting single row into multiple values

sunny_talwar — Tue, 20 Sep 2016 10:52:28 GMT

May be it is Chr(10)

SubField(Name, Chr(10))

SubField(Name, Chr(13))

SubField(Name, Chr(13)&Chr(10))

UPDATE: You are trying to do this in the script right?

Re: splitting single row into multiple values

Anonymous — Tue, 20 Sep 2016 11:13:45 GMT

yes,,chr(10) worked