Let's say I have two tables within Easymorph (they aren't external tables/excel files) with the exact same column names, or at least the column names are the same but one table might have more/less of them....but for the columns that do exist they have the same names.
Now I want to combine the two sheets into one with having only one unique row for the part number but merging the headers and respective data.
For example:
Table A:
Table B:
RESULT:
I thought append function would do this but it doesn't seem to do what I want...and I don't see any options in the Merge functions to do this either?
I use merge all the time but if I do a merge here and say the unique field is part number - to match on, and then say pull in the Attributes from table B, it's going to add them to the end of Table A, having duplicate columns. I don't want duplicate columns, I just want it to fill in table A's columns with the data in Table B where the column names are the same assuming table A columns values are blank.
In that case, I would first delete all empty columns and then do the merge.
I can't do that either since my dataset is 10 Million Part_Numbers and the columns that have blanks from one item to the next is different.
Just a little example from my private laptop (with the free version):
merge.morph (4.0 KB)
Table 1.dset (2.0 KB)
Table 2.dset (2.0 KB)
1 Like
Ahh many thanks, I've only been using the unpivot here recently so still getting a grasp on it's use cases. Thank you for this!
1 Like
