Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

how to write 'Pick Match' to replace IF with multiple parameters

I have below two expressions from two different tables, now I need to merge these conditions in one and display in one table.

how to write Pick(Match ())function to replace IF and merge these two ? Not sure how to use multiple parameters here. Below are the expressions -

=if(OStype='Windows 10/11'and (date=vCurrentDate or date=vLast7Day) ,buildnumber&'-'&version)

=if(OStype='Non-Windows 10/11' and (date=vCurrentDate or date=vLast7Day )  ,OS system)

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

=if(date=vCurrentDate or date=vLast7Day

,pick(wildmatch(OStype,'Windows 10/11','Non-Windows 10/11'),

buildnumber&'-'&version , [OS system] )  )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

=if(date=vCurrentDate or date=vLast7Day

,pick(wildmatch(OStype,'Windows 10/11','Non-Windows 10/11'),

buildnumber&'-'&version , [OS system] )  )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
abc_18
Creator II
Creator II
Author

Thanks Vineeth, it's working