2 Replies Latest reply on Sep 9, 2015 9:19 PM by Courtney Connolly

    How to compare dissimilar data sources

    Courtney Connolly

       

      All my data sources are flat standalone Excel files organized by year of activity.  The individual Excel data sources for each year are not all necessarily structured the same (e.g. different field headers, different results under an otherwise common field across years).  Is there a way to compare results from these dissimilar data sources without having to manually clean up the separate data sources so they are in the same format and can be joined?