Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Community,
Load * inline [
ID, Stage
100, 'Abc,123, JDB'
101, '123,BBB,JHJ'
102, 'ABC123, BCA, DCA'
103, 'CDA,JUJ,123'
];
Here, I have one Stage field, in that if i have any where 123 i want to return data.
My output should be
ID, Stage
100,123
101, 123
103,123
Thanks in Advance....
Load * Where Stage='123';
Load ID, SubField(Stage, ',') as Stage
inline [
ID, Stage
100, 'Abc,123, JDB'
101, '123,BBB,JHJ'
102, 'ABC123, BCA, DCA'
103, 'CDA,JUJ,123'
];
only(if(WildMatch(Stage, '123,*', '*,123', '*,123,*'), 123))
Hi Paul,
You can use this expression to get your desired output:
if(WildMatch(Stage, '*123*'), 123)
Hope it helps you!!
if(WildMatch(Stage, '*123*'), 123)
Load * Where Stage='123';
Load ID, SubField(Stage, ',') as Stage
inline [
ID, Stage
100, 'Abc,123, JDB'
101, '123,BBB,JHJ'
102, 'ABC123, BCA, DCA'
103, 'CDA,JUJ,123'
];
Hi Paul,
You can achieve the result by Massimo Grossi Solution.
Thanks @Massimo Grossi
maybe also possible:
If(WildMatch(','&Stage&',', '*,123,*'), 123)
hope this helps
regards
Marco