Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Digital Support
Digital Support

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.