2 Replies Latest reply: Nov 17, 2015 4:40 AM by Ralf Becher RSS

    Loading a field that isn't always there

      I am loading XML files that provide a series of fields only if there is data within them. See example below. I cannot load *, otherwise I would do that first and then transform the resident table. Is there a way for me to check to see if a field is there before loading the file?

       

      Monday's Extract (three fields):

      OrderIDAmountLocation
      110Mexico
      24Canada
      35

      England

       

      Tuesday's Extract (four fields):  

      OrderIDAmountLocationState
      110Mexico
      24Canada
      35England
      41USANY

      Thanks in advance!