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.
Solucionado! Ir para Solução.
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?
@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.
@CharlieS here is the other file.
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.