This content has been marked as final. Show 3 replies
I would like to create a mapping table containing an ID and a Name field. I want the mapping table only to be filled for a special pattern in the name field:
'DExxxx', where the x's are numbers like 'DE1234'
Problem is, that the source contains enough different values like 'ENxxxx' or even names like 'Amacut' or 'Beedot'. How can I filter my pattern during load?
My current solution is LOAD if(wildmatch(NAME, 'AM*'), NAME) as Name
but this does include the 'Amacut' from my previous example and several others.