5 Replies Latest reply: Oct 22, 2014 12:21 PM by Madhusudhan Ramachandran RSS

    Wildcards in field name?

      Hello,

       

      I'm loading several tabs from 1 excel sheet by looping them and concatenate them in FACTS.

      This works fine if all fields on all tabs are exactly the same, but that is not the case.

       

      One column on every sheet has a different name e.g. [Amount (EUR)], [Amount (MYR)], [Amount (USD)].

      What I want to do is something like this:

       

      load [Amount (*)] as Amount

       

      or

       

      load [Amount (???)] as Amount

       

      but that is not working. Does anybody have an idea?

       

      Thanks in advance.

       

      Regards,

      Alexander