Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jbhatt1810
Contributor III
Contributor III
‎2020-08-10 05:15 PM

Can we make Join optional in tMap?

I have a requirement where I want to make join optional. For example, main.C1 join lookup.C1 and if that join fails then further join main.C1 join lookup.C2. Is this possible in tMap? If yes, how to Achieve this?

Labels (2)
Labels
84 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2020-08-11 04:56 AM

@Janki Bhatt​ , it is impossible do it! Filter the data and use them to do another join.

 

Regards

Shong

84 Views
0 Likes
jbhatt1810
Contributor III
Contributor III
‎2020-08-11 11:33 AM
Author

Ok Thanks @Shicong Hong​. Is it possible to join two or more columns from Main table to single column of lookup table? Example, main.C1, main.C2 join lookup.C3 . If yes, then what would be the expression? I tried keyword AND and && but didnt work.

84 Views
0 Likes