Hello!
I have a several inputs that all have roughly the same format except with a different amount of rows. The format is a list of items followed by an amount of items, but some files have more items than other. For example, File 1 might have
Apples 5
Orange 3
Bananas 6
and File 2 might just have
Apples 3
Bananas 10
I want to do a union and crosstab to get a result similar to this:
Fruit FIle 1 File 2
Apples 5 3
Orange 3
Bananas 6 10
I don't have a problem getting to this point but I'm having some trouble preserving the item order. I tried to do record ID and group by RecordID in the cross tab tool but that doesn't work because each file has a different amount of rows therefore Apples might not have the same RecordID in each file causing the output to have a row for each instance of Apple rather than showing up in one row. Any help would be greatly appreciated, thanks!
