Datasets Connection

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.

Datasets

Data Investigation

Accepted answers

All comments

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,

atcodedog05

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

Qiu

@atcodedog05
Back in business? 😁

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.

Data 1.xlsx

Data 2.xlsx

Output.xlsx

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335