How to use INDEX+MATCH in Alteryx

[Bella_Gan]

Input:

1.Actual Delivery Date	2.Booked For Delivery (BD) Event Date	3.Available For Booking (BK) Event Date	4.Actual Arrival Date	5.ATD	6.AHD
28/02/2025	28/02/2025	27/02/2025	22/02/2025	16/01/2025	04/01/2025
	11/03/2025	25/02/2025	21/03/2025	09/01/2025	04/01/2025
				09/02/2025	31/01/2025
					24/03/2025

Expected Output: to find the last event date and get the corresponding column name

Milestone category

1.Actual Delivery Date

4.Actual Arrival Date

5.ATD

6.AHD

[KGT]

I'm not sure exactly what you're after here, as I don't know what event date correlates to those columns. There's no common date between those 4 columns.

To get the last event date, use a summarise on that column and get Max.

If you transpose all the data, then you can join on that Max_date and the [Value] field of the transposed data. The [Name] field will be your column name.

If you are looking for matches that aren't exact, then it requires a lot more logic.

[Bella_Gan]

1.Actual Delivery Date	2.Booked For Delivery (BD) Event Date	3.Available For Booking (BK) Event Date	4.Actual Arrival Date	5.ATD	6.AHD	Milestone category
28/02/2025	28/02/2025	27/02/2025	22/02/2025	16/01/2025	04/01/2025	1.Actual Delivery Date
	11/03/2025	25/02/2025	21/03/2025	09/01/2025	04/01/2025	4.Actual Arrival Date
				09/02/2025	31/01/2025	5.ATD
					24/03/2025	6.AHD

This is what I want finally, and I also attached a picture here to show how this happen in excel file, I just don't know how to achieve this in Alteryx file, what's formula would be?

[KGT]

It's been a while, as I haven't been active, but I'll place the answer in case it's still unresolved.

Remember to make your dates into proper dates, not strings like in the screenshot.

• Set a RecordID (This will help with sorting)
• Transpose all columns
• Sort by Name, RecordID
• Summarise with grouping on Name, and taking Last([Value], Max([Value]

That will give you both the Max date on each column and the last value in each column, depending what you are after.