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

If Statement

Hello,

 

I have two columns drivercompletedby and asvrcompletedby. Im trying to use both columns to return ran&unrun based on the following:

drivercompletedby ='MES$' or '' and asvrcompleted by='' returns unrun, rest would be ran. Any help is appreciated.

Labels (1)
1 Solution

Accepted Solutions
Iswarya_
Creator
Creator

Hi @danieldors ,

=IF(WildMatch(drivercompletedby,'MES$','') and WildMatch(asvrcompletedby,''),'Unrun','Ran')

View solution in original post

2 Replies
Digvijay_Singh

Pl share some sample data and expected output, I am sure someone would be help you out to format your IF statement.

Iswarya_
Creator
Creator

Hi @danieldors ,

=IF(WildMatch(drivercompletedby,'MES$','') and WildMatch(asvrcompletedby,''),'Unrun','Ran')