Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You need like in such case: ... Field like '*value*' ... or maybe switching to: ... wildmatch(Field, '*value*')
- Marcus
You need like in such case: ... Field like '*value*' ... or maybe switching to: ... wildmatch(Field, '*value*')
- Marcus
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