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
Solved! Go to 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.
Thank you nagakavyasri for helping me resolve this with a different tool.
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.