Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Join a lookup file at different key levels

Hello

I've got two data tables I want to join together in an unusual way.

There are two key fields but the lookup file might only specify one of them. If it does then that lookup value needs to apply to all records with that value.

The example might clarify.

For code A, in the lookup, codes have been defined for groups A2 and A3

For code B, the lookup only specifies it at that level so the lookup value (blue) is applied to all B records

For code C, again the lookup specifies it at code 1 and code 2 level

The D code lookup is only specified at the code 1 level, so the value (black) is applied to all D records.

I was thinking I could read the lookup file and split it depending on whether it has a code 2 value or not. Then do a join at the code1/code2 level and another at the code1 only level. But I don't really know how to script this.

I want the full lookup code1/code2 to override the code1 only lookup.

Hope this makes sense, any help would be appreciated!

Thanks.

1 Solution

Accepted Solutions
john_duffy
Partner - Creator III
Partner - Creator III

Hello.

I have attached an application with script logic to join the two tables as described above.

Let me know if this helps.

John.

View solution in original post

2 Replies
john_duffy
Partner - Creator III
Partner - Creator III

Hello.

I have attached an application with script logic to join the two tables as described above.

Let me know if this helps.

John.

Not applicable
Author

That's awesome, thanks so much for your help!