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?
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()
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...
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 ...
