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: 
Sxbbb
Creator III
Creator III

I want to display only matching Workorder data.

EX. 

There is a WorkOrder with 3 data values

Sxbbb_0-1676344854317.png

 

i use code

Suchanan_1-1676343414491.png

Result 

but showing Open for every WorkOrder

Sxbbb_1-1676344883400.png

It has to be Open 3
Only matches the WorkOrder with data. 

I want Open to show only WorkOrder values.

 

6 Replies
MayilVahanan

Hi

You can add if condition based on ur condition like

If(Match(WorkOrder, 'a', 'b', 'c'), 'Open URL', '')

Instead of a, b, c, u can change based on ur scenario

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Sxbbb
Creator III
Creator III
Author

different workOrder numbers after A . 

WorkOrder Example

 

Sxbbb_1-1676347650483.png

 

 

Sxbbb
Creator III
Creator III
Author

WorkOrder Example

Sxbbb_0-1676347905205.png

 

MayilVahanan

So, you want to check the work order starts with A?

If so, try like below

If(wildMatch(WorkOrder, 'A*'), 'Open URL', '')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Sxbbb
Creator III
Creator III
Author

No, I need it to match every WorkOrder to show Open.
Sxbbb
Creator III
Creator III
Author

I want workorder to match every number