5 Replies Latest reply: Feb 3, 2017 10:12 AM by Bill Markham RSS

    How to structure data coming from several similar data sources?

    Paul Senior

      I need to take ERP GL transactional data from 4 different companies. I need to merge it but I also need to be able to identify which company each row came from. There is nothing in the data itself to identify this. The data will be coming from different SQL database names but other than that it is identical in structure. I've done several visualistions from single databases and added data from other sources, but I've never combined 4 like this.

       

      Any ideas how I should approach this? A simple company identifier against each line? If so, what is the best way to attach this. There are several empty columns in the data that could be utilised if necessary.

       

      Thanks!