4 Replies Latest reply: Dec 17, 2009 11:27 AM by Lucian Cotea RSS

    load a field only if it exists in the data source

    Amirali Vastani

      I want to be able to check in the load script if my excel source or a text file source has a particular column and then load it. The reason being I have a for loop around it that cycles through all the files in the directory and if one file doesn't have that column in the source, then my process errors out for that file but continues on.

      I would like for the script to intelligently check if that column exists and only then load it.

      any tips? thanks.