Select the max value when [Table_1.Field_1] <= [Table_2.Field_2]

[wellington_costa]

Hi, I need to fill the field Tax impact in Table B when:

- Table_A.Cod = Table_B.Cod and

- Max Value(Table_A.Month <= Table_A.Month) 

Table A				Table B
Year_Month	Cod	Tax Impact		Year_Month	Cod	Tax Impact
201801	1000	1		201901	1000
202004	1000	2		202005	1000
202005	1000	3		202101	1000
202007	1000	4
202008	1000	5
202012	1000	6

Resolution:

Thanks

[BrandonB · Accepted solution]

I think that this workflow should do the trick. Screenshot is below and workflow is attached. 

 

[wellington_costa]

Thanks