Compare between 2 files , and create new file with sheet names Trade, Document, Difference

Hi Team,

I have 2 files which i need to be compared and create new sheet in Alteryx, which needs to be joined on the basics of ISIN column

expected output file has been attached at end I'm looking for all sheets need to be in one file ( Trade, Document, Difference)

if background highlight is not possible at least mark difference amount in red color

File : 1 ( Trade)

File : 2 (Document)

Accepted answers

Like so:

If you want to further customize the look and feel, refer here:

@caltang
Thank you. I was struggling with how to assign the Sheet name with Render tool. Learned new thing from you.

@BRRLL99
I have similar approach with @caltang with slight difference on the Column Rule using.

Input Data:
- Read both files ("Trade" and "Document") into Alteryx using the Input Data tool.
Join Tool:
- Use the Join tool to combine the two datasets based on the "ISIN" column.
- Configure the Join tool to join on the "ISIN" column.
Select Tool:
- Use the Select tool to choose the columns you want to include in the output.
Formula Tool for Difference:
- Add a Formula tool to calculate the difference between corresponding columns from both files.
- For example, if you want the difference in "Col_Amount," the formula would be something like: [Col_Amount_Trade] - [Col_Amount_Document].
Filter/Conditional Formatting:
- If you want to highlight the differences, you can use the Filter tool to separate rows with differences.
- For conditional formatting (like red color), you can use the Multi-Row Formula tool to add an HTML tag for styling based on the calculated difference.

IF [Difference] < 0 THEN "<span style='color:red'>" + STR([Difference]) + "</span>" ELSE STR([Difference]) ENDIF

Union Tool:
- Use the Union tool to combine the original data with the calculated differences.
Output Data:
- Finally, use the Output Data tool to save the combined and modified data to a new sheet or file.