Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
=if(date=vCurrentDate or date=vLast7Day
,pick(wildmatch(OStype,'Windows 10/11','Non-Windows 10/11'),
buildnumber&'-'&version , [OS system] ) )
=if(date=vCurrentDate or date=vLast7Day
,pick(wildmatch(OStype,'Windows 10/11','Non-Windows 10/11'),
buildnumber&'-'&version , [OS system] ) )
Thanks Vineeth, it's working