combining data a different way (sort of like appending)

Follow

n

• June 20, 2018 19:10

Hi everyone,

 

I am trying to combine multiple reports but I don't want to combine any data  if is a match in the column so I can't do a join.

 

for example I have two reports that have some matching column titles and a few that don't match. Below is an example

A, B, C are the match column titles 

Beport 1 : A B C D E

Report 2 : A B C X Z 

combined I want the finished workbook to look like this

 

Workbook : A B C D E X Z

 

here the columns that don't match  are separated to the side and still intact. 

 

Is there a why in datameer that I can do this? 

 

I hope this makes sense

0

• 

  Joel Stewart

  • June 20, 2018 19:22

  The way I would do this is to add the extra columns (with empty results) into each of the sources and then use a UNION function to bring the two data sets together into a single sheet. 

  In your example, I'd specifically add columns X and Z to Report 1 and columns D and E to Report 2 then perform the union on those results. 

  Hope this helps! 

  1

  Comment actions Permalink
• 

  n

  • June 21, 2018 14:38
  • Edited

  yikes OK look like I have to manually add 50+ the extra columns then 

  0

  Comment actions Permalink

Please sign in to leave a comment.