Change end date

[Istwineres]

Hi all! 

I have this input file: 

             col1   col2       col3            col4           col5

row1  MAN 0QQ31                     0,36000 2020-07-02
row2  MAN 0QQ31 01-07-2020 0,36000 2020-07-01
row3  MAN 0QQ31 04-06-2020 0,36000 2020-06-04
row4  MAN 0QQ31 07-04-2020 0,36000 2020-04-07

row5  MAN 0A28TY6                     0,90000 2020-07-02
row6  MAN 0A28TY6 01-07-2020 0,90000 2020-07-01

I want to change for the last data into col2 the col5 into a fake date (eg. 01/01/1999). So row4/col5 should be 01/01/1999 and row6/col5 should be 01/01/1999.

Many thanks

[Jean-Balteryx]

Hi @Istwineres ,

You specifically need those two values to be 01/01/1999 or you need the two last rows to get this value in col5 ?

[Istwineres]

Yes, those 2 cells have to be filled with the fake date

[Jean-Balteryx]

Here is a workflow changing your values specifically for last two rows in col5.

Basically it adds a recordID so you can use it in a formula tool to change only for rows 5 and 6.

[Istwineres]

No, row4 and row6 have to be changed

[Jean-Balteryx]

My bad, misread. You only have to change 5 to 4 in the condition in the formula tool !

[Istwineres]

Unfortunately the input file was just an extract and the solution have to be dynamic, I don't know how many records for col1 will be present

[Jean-Balteryx]

So dynamically, which records need to be changed ? The last and the one two rows before ?

[Istwineres]

 The last one for each different record based on col1 and col2 so in the example row4  and row6

[Jean-Balteryx]

I updated the workflow to match your need and dynamically change the value of the last row for each combination col1/col2.