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: 
NemoAndStitch22
Contributor III
Contributor III

How to match based on which criteria

Hiya,

 

I've got 3 data sets - Enquiries, Quotes and Sales that I need to match between.

Essentially I would like to follow the enquiries through to sales.

I have two ways of following the enquiry through, either through the enquiry number or through a unique identifier that I've created from the customer name and postcode.

 

I've given all 3 of my data sets the unique identifier and all data sets have the enquiry number... I need both fields as the enquiry number can sometimes change so the UID is a back up to match on. 

What I would like to do is create a field to say 'if the enquiry number is the same, say "Enquiry Match", if the UID is the same, say "UID Match", otherwise no match'.

 

I've loaded all 3 of my data sets as just straight loads, I can left join if needed, but I don't know how to link them in the same way I would if it was excel where I would just use a multiple if statement with lookups in.

 

Hopefully this makes sense.

0 Replies