Matching Fields

Question

Hi All

I have a file with a number of different investments across two datasets which I have joined into one stream with a number of other fields as well similar to the below example. My goal is to combine the data into one line that matches each investment and all the other fields involved.

InvestmentInvestmentFilePrice1Price2Field1Field2Field3Field4Field5Field6A   DataDataDataDataDataDataB   DataDataDataDataDataDataC   DataDataDataDataDataData A12       B34       C56

My desired end result would be similar to the below

InvestmentInvestmentFilePrice1Price2Field1Field2Field3Field4Field5Field6AA12DataDataDataDataDataDataBB34DataDataDataDataDataDataCC56DataDataDataDataDataData

I have tried using the transpose and cross tab functions but with all the other columns it isn't working well.

Anyone have an idea of how I would accomplish the desired results?

Thank you in advance!

usmanbashir · Accepted Answer

Instead of appending the two data sets (union), perform a join where the key is on Investment.

ScottLewis · Accepted Answer

I made the assumption that the union happened before bringing the data into Alteryx. If the union is something you're doing then usmanbashir's answer is correct, you should just be joining rather than unioning.

If it is coming in stacked like that here's the logic to split it and recombine.

nagakavyasri · Accepted Answer

@arosenberg1995 Use Join instead of Union. Union appends data vertically, Join appends data horizontally.