3 Replies Latest reply: Nov 18, 2013 9:32 AM by Clever Anjos RSS

    For a mapping table: Load only certain entries from a table

    Jens Zibell



      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.