Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

FlaviaJ
5 - Atom

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

4 REPLIES 4
kylecoleman
6 - Meteoroid

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
12 - Quasar

@FlaviaJ You can try using this:

 

Screenshot 2024-03-07 171730.png

FlaviaJ
5 - Atom

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

FlaviaJ
5 - Atom

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.

Labels