Updating a column based on another value

[vrbravo]

Hi All,

I have the below scenario, Can someone please help.

Type	Start Date	End Date
0	2019-07-20	2019-10-18
1	2019-08-21	2019-10-18
0	2019-08-31	2019-10-25
1	2019-10-19	2019-10-25

In above table, i need to replace the start date value of indicator 1 to that of Indicator 0's start date  for all the records in a table..

Below is desired output

Type	Start Date	End Date
0	7/20/2019	10/18/2019
1	7/20/2019	10/18/2019
0	8/31/2019	10/25/2019
1	8/31/2019	10/25/2019

[fmvizcaino · Accepted solution]

Hi @vrbravo ,

Attached is an example showing how to accomplish that. I'm using the multi-row formula to update the needed values.

https://help.alteryx.com/2019.3/MultiRowFormula.htm

Let me know if that works for you.

Best,

Fernando V.

[RolandSchubert · Accepted solution]

Hi @vrbravo ,

this can be done using a Multi-Row Formula tool (but will work only, if rows are in sequence as in your sample)

See attached workflow.

Best

Roland