7 Replies Latest reply on Mar 9, 2017 6:10 AM by Jim Dehner

    Merging two excel sheets (blending/joining)

    Mikkel Christensen

      Hi!

       

      I have two excel data sources that I would like to merge by either blending or joining. In my primary data source I have a couple of more dimensions that the secondary source (example below). It is important that none of my data are overwritten by the other source.

       

      My question is how it get my ID dimension from the primary and secondary source to merge into one column?

       

      I have made two test data sources (blend 1 and blend 2):

      Thank you!

       

      Regards,

       

      Mikkel