Max and Min Date with a multi row tool

[wonka1234]

Hi,

This seems like a job for a multi row tool.

How to find the max and min dates of this dataset? I feel like I need to go into both rows for each n_value.

I was trying to this but i dont think it applies to both rows for each n_value.

MAX_DATE = if [c_Action_Date] <= [File_date_with_days] then [Value] else "" endif

sample data:

N_VALUE	c_Action_Date	File_date_with_days	Name	Value
jon	6/27/2022	10/13/2022	202210	Y
jon	6/27/2022	10/13/2022	202211
joey	6/27/2022	10/13/2022	202210	Y
joey	6/27/2022	10/13/2022	202211
kim	6/27/2022	10/13/2022	202210	Y
kim	6/27/2022	10/13/2022	202211
lou	6/27/2022	10/13/2022	202210	Y
lou	6/27/2022	10/13/2022	202211
ren	6/27/2022	10/13/2022	202210	Y
ren	6/27/2022	10/13/2022	202211
bob	6/27/2022	10/13/2022	202210	Y
bob	6/27/2022	10/13/2022	202211
andrew	6/27/2022	10/13/2022	202210	Y
andrew	6/27/2022	10/13/2022	202211
joe	6/27/2022	10/13/2022	202210	Y
joe	6/27/2022	10/13/2022	202211
don	6/27/2022	10/13/2022	202210	Y
don	6/27/2022	10/13/2022	202211
rudy	6/27/2022	10/13/2022	202210	Y
rudy	6/27/2022	10/13/2022	202211
bobby	6/27/2022	11/13/2022	202210
bobby	6/27/2022	11/13/2022	202211	Y
drew	6/27/2022	11/13/2022	202210
drew	6/27/2022	11/13/2022	202211	Y
carlos	6/27/2022	11/13/2022	202210
carlos	6/27/2022	11/13/2022	202211	Y
pete	6/27/2022	11/13/2022	202210
pete	6/27/2022	11/13/2022	202211	Y
jamie	6/27/2022	11/13/2022	202210
jamie	6/27/2022	11/13/2022	202211	Y
justin	6/27/2022	11/13/2022	202210
justin	6/27/2022	11/13/2022	202211	Y
rich	6/27/2022	11/13/2022	202210
rich	6/27/2022	11/13/2022	202211	Y
rob	6/27/2022	11/13/2022	202210
rob	6/27/2022	11/13/2022	202211	Y
trevor	6/27/2022	11/13/2022	202210
trevor	6/27/2022	11/13/2022	202211	Y
adam	6/27/2022	11/13/2022	202210
adam	6/27/2022	11/13/2022	202211	Y

[SPetrie]

Is there any particular reason you want to use a multi-row or is that just how you were thinking of going about it? If you ware just looking for the max/min dates for each person a transpose and then summarize may be easier.

Transpose the data so the dates are in one column vs. two, then convert to a date value. You can then use a summarize to get your max and min dates and group it by person.

[wonka1234]

@SPetrie  would you be able to attach the workbook?

[SPetrie]

Sure. Here you go.