Datasets Connection

[gmamtani]

HI Alteryx community, 
Happy Monday

Please help me with this. Thanks in advance

Data 1: I have a data set with lots of financial metrics like revenue, debt to equity, ROI, roce, employee etc. This data set has around 500 companies 
Data 2: I have another set of data with only revenue and it has 1000 companies.

I want to combine and get the output in such a manner that if the data of the company is not there in Data 1 then in the revenue and employee should be sourced from Data 2 and vice a versa.

Also in the output it should mention in a column from which Data 1 or Data 2 the data is populated .

Please help.

[mceleavey]

Hi @gmamtani ,

If you could provide the data (mock data is fine) and give an example using the data of what you would like to see this would be a big help to those on here.

Thanks,

M

[atcodedog05]

Come on @mceleavey, You should be able to work your magic without them saying what they want 😏

[Qiu]

@atcodedog05 
Back in business? 😁

[mceleavey]

I'm too old for that now, Kiran.

[atcodedog05]

---

@Qiu wrote:

@atcodedog05 
Back in business? 😁

---

@Qiu 

Not sure, lets see 😅

But would love to tough 😁

[gmamtani]

Thanks. 

Attached is the mock data sheets. Data 1 and Data 2. 

In the output you have the revenue and employees from data 2 because it is not there in data 1.
now there could be a case where the figures are not in data 2 but present in data 1 so it is populating accordingly. 

[atcodedog05]

Hi @gmamtani,

It will be roughly like this. You need to work around it.

Hope this helps : )

[gmamtani]

Thanks @atcodedog05 

Really appreciate your help :). 

I will try this out and see if this is working, 

Thanks Again,