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

Question

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

Verizon Statement 2024-03-04 19.59.47.xlsx

Alteryx PWC Workflow1.yxmd

kylecoleman · Accepted Answer

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 Answer

@FlaviaJ You can try using this: