How to add a Date located in one column to another column using the multi row tool?

[FlaviaJ]

I'm having trouble creating the expression to move a date found in Cell B2 to column called date at the end of the worksheet and to populate it all the way down to the end row.

Here is my current expression:  IF ISEMPTY([Date]) THEN [Row-1:Date] ELSE [Date] ENDIF

[kylecoleman · Accepted solution]

I think you'll find success using Append Fields while filtering the source data to rows where Statement Date is in your first column. This works without having to write an expression. You'll have to re-direct the file reading bits if you want to run the one I've attached.

[nagakavyasri · Accepted solution]

@FlaviaJ You can try using this:

[FlaviaJ]

Thank you nagakavyasri for helping me resolve this with a different tool.

[FlaviaJ]

Thank you Kylecoleman for helping me.   This simple task was frustrating me.

I also realized the Data Cleansing didn't have the fields checked off so that also fixed my problem.