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
Please sign in to leave a comment.