Discussion board where members can get started with Qlik Sense.
I need your support to solve this issue in Qlik Sense:
I have 2 tables:
I need this output:
Thanks for your help,
Maye be 🙂
mapping load *,'_'&CCode&',' as Value;
Load Section,ID,subfield(SubNewdetail,',',1) as Name,subfield(SubNewdetail,',',2) as Details where len(SubNewdetail)>0;
load Section,ID,subfield(Newdetail,'_') as SubNewdetail ;
LOAD *,MapSubString('map1', Details) As Newdetail INLINE [
Section, ID, Details
1, 1a, HOMExxxxxxxxxxxCARxxxxCHAIRxxxxx
1, 1b, CHAIRxxxxHOMExxCARx
1, 1c, CHAIRxxxx
View solution in original post
Thank you. It is working.
What if I only need to split by rows?
Can you develop a little bit more
Oh, it is ok, I just realized i can adapt the code you sent.