If = statement in load using wildcard function

[davyqliks]

Hi,

Thank you for your time in advance......

I am having trouble using an If = statement as below using a wild card (*)

If i load as this

Load
Items,

If(Items =
'JF CL WARN' ,

Items) As [Warning Label]

The result is as expected and the Ref 'JF CL WARN'  is shown as a [Warning Label]

However, if i load as follows:

Load
Items,

If(Items =
'*WARN*' ,

Items) As [Warning Label]

i do not associate the required item as a warning label

I would like to use wild card so i can capture multiple labels with 'WARN' in the name.

Thank you so Much for your help,

Regards

Daniel

[marcus_sommer · Accepted solution]

You need like in such case: ... Field like '*value*' ... or maybe switching to: ... wildmatch(Field, '*value*')

- Marcus

[davyqliks]

This is perfect,

thanks, i achieved like the below based on comments:

Load
Items,
If(WildMatch(Items,'*CL*'),Items) as [Care Labels]
Resident ItemLoads
where not WildMatch(Items,'JF CL WARN')

Thank you

Daniel