Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to see if there is a way to use another field within a LOAD in a WildMatch function.
I have a field that contains a number and some other characters like "1234_testing_iso" or "12345_impala_pad" and then I have another field which is essentially a cost code such as "1234" or "2345".
I am trying to see if I can make a WildMatch function using the second field as the expression to reference.
Field1 = 1234_testing_iso or 12345_impala_pad
Field2 = 1234 or 12345
What I had in mind would be something like:
IF(WIldMatch(Field1,'*(Field2)*'),'Match','No Match')
If it was comparing "1234_testing_iso" to field 2 (1234) there would be a "Match". Comparing it to (2345) would get "No Match".
Comparing "12345_impala_pad" to (1234) would be a "Match" and compared to (2345) would also be a "Match"
Ideas?
I think you might need to use MapSubString here