Updating a column based on another value

Question

Hi All,

I have the below scenario, Can someone please help.

TypeStart DateEnd Date02019-07-202019-10-1812019-08-212019-10-1802019-08-312019-10-2512019-10-192019-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

TypeStart DateEnd Date07/20/201910/18/201917/20/201910/18/201908/31/201910/25/201918/31/201910/25/2019

fmvizcaino · Accepted Answer

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 Answer

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