topic Re: Split values into rows in QlikView

Split values into rows

vijetas42 — Mon, 23 Apr 2018 07:42:27 GMT

Hi All,

Is there any way apart from subfield() to split the values in rows?because,currently we are using expression like,subfield(applymap('MAP2',Key),'#') and it's giving out of object memory error so is there any other function to split values into rows?

Regards,

Vijeta

Re: Split values into rows

techvarun — Mon, 23 Apr 2018 08:05:45 GMT

Share sample inputs and Expected output

Re: Split values into rows

vijetas42 — Mon, 23 Apr 2018 08:40:48 GMT

I don't have any sample data to share for now.as due to some data model requirement we are first concatenating value with '#' and then just removing it. but as we are getting error is there any other alternative to subfield()

Re: Split values into rows

sunny_talwar — Mon, 23 Apr 2018 11:41:25 GMT

Without knowing or seeing your data... it will difficult to comment... what is the issue with sharing mocked up dummy data which is close to your actual data...

Re: Split values into rows

MarcoWedel — Mon, 23 Apr 2018 20:36:42 GMT

First concatenating and subsequently separating some values seems odd. There have to be other (potentially simpler) solutions, which might be difficult to advise without having details to work with ...