Comparing Dates in two excel files

[KamalChoudhary_in]

HI Team,

Im tying to compare two excel worksheets, commnon identifier between them is Column(Account)

I want to update column Comments Match if

Account,

Intimation Date,

EndDate

all three are matching else Nomatch in Comments

	TABLE A					TABLE B
EndDate	Intimation Date	Account	Comments		EndDate	Intimation Date	Account
04 November 2022	21 October 2022	456	Match		20 February 2022	06 February 2022	123
20 February 2022	06 February 2022	123	Match		04 November 2022	21 October 2022	456
22 March 2022	06 March 2022	123	Nomatch		05 October 2022	21 September 2023	456
20 March 2022	08 March 2022	123	Nomatch		30 November 2022	16 November 2022	789
30 November 2022	16 November 2022	789	Match		31 January 2023	17 January 2023	789
30 December 2022	16 December 2022	789	Nomatch		30 September 2023	16 September 2023	789
31 January 2023	17 January 2023	789	Match		31 October 2022	17 October 2022	789

[PhilipL]

Hi @KamalChoudhary_in 

This is one of many ways to approach this in Alteryx. A cleaner solution would add cleanups/conversions of your date fields to actually be dates.

[nagakavyasri]

One way:

[PhilipL]

Hi @nagakavyasri,

Your solution might need a 3rd formula to pick up the unmatched records from the Join (R) output. It's possible they may be different from the Join (L) unmatched records.

Cheers!

Phil

[nagakavyasri]

Yeah,right! Thank you!