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

      Hi,

       

      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.

       

      Thanks.