Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ramsingh
Contributor
Contributor

Scripting - Filling Null values

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

1 Reply
Brett_Bleess
Former Employee
Former Employee

I think you will need the following:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Strin...

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.