Convert 2 Output Reports in One Report

Hi,

I Just want to know if anyone knows which is the best approach in order to convert 2 Output Data Results in 1 Report, I already try several times however, I just a duplicate the scenario, the result should be 409 rows.

Please let me know if anyone know which is the best approach in order to convert these 2 output files keeping the criteria for each file.

Primary location Report for Attribute Verification.yxmd

Reporting

Connectors

Common Use Cases

Best Practices

Apps

Preparation

Expression

Interface Tools

Data Investigation

Database Connection

Prescriptive Analytics

Accepted answers

CharlieS

It looks like Account Number is the unique identifying field between the two data sources. I used that to join the geocode data to the 12 records that it was available for. After that, since I still wanted the unmatched (outer-join) results from the Location report, I used the Union tool to add the unmatched records. The final output has 409 records.

Check out the attached example solution and let me know if you have any questions.

20181024-JoinGeoData.yxmd

All comments

CharlieS

Without the input data files, I can't say for sure what the best course of action is. If that data (or a sample) cannot be shared, here's a few questions to guide this process:

- Do both outputs have the same fields and you'd like the results union-ed ("stacked") into one table of results?

- Would you like them on different sheets of the same Excel workbook?

SebasWU

@CharlieS Thanks for your answer let me attached both files.

- Do both outputs have the same fields and you'd like the results union-ed ("stacked") into one table of results? Yes this is What I need.

Primary Location Report - Attribute Verification.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703