Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
Have kind of basic question i guess
Need help
I have table with 2 fields
ID's Name
1 Apple
2 Orange
3 Mango
1_1 -
1_2 -
1_3 -
2_2 -
3_1 -
3_2 -
I have above table where Names are null for 1_1 , 1_2 ,1_3 ,2_2,3_1,3_2
I could require below table as output ( To be done in Backend )
ID's Name
1 Apple
2 Orange
3 Mango
1_1 Apple
1_2 Apple
1_3 Apple
2_2 Orange
3_1 Mango
3_2 Mango
Basically for the null values , based on left of ( before underscore ex 1_1 , 2_2) and map with above ID's and get the names
Advance Thanks
I think you will need the following:
The other option may be a Mapping load I think:
https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192
About the best I have to try to get you on the right track with things, there are likely other ways as well. if you did not search Community for prior posts, try that too, as I know there are others out there like this.
Regards,
Brett