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: 
Anonymous
Not applicable

Linking Lookup field

Hi All,

I have an existing Data model with customer name and customer id tables.. Now i have got a new excel to link with it. This excel has some columns.

Major ones are:

Customer ID, Customer Name and Look Up .

Not all Customer Names have a Customer ID. So i want to link this table with my data model using the lookup field like, if there is a Customer ID then through Customer ID and if there isn't a Customer ID, then through Customer name.

Look Up has two values Customer name and Customer Id depending on the lookup type.

Can anyone help me in this?

Thanks.

0 Replies