Alteryx Designer Desktop Discussions

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

copy paste

amitsingh145
8 - Asteroid

Hi,

 

I just want to copy the content of first column to next column and so on.

Just like in the excel file.

Please suggest.

Thanks

 

9 REPLIES 9
Ladarthure
14 - Magnetar
14 - Magnetar

Hi,

 

to do so, you cna use the multi-row formula which allows you to make a reference to a previous line (see attached workflow for details)

GiuseppeC
Alteryx
Alteryx

Hi @amitsingh145,

 

I may have misinterpreted what you want to achieve, but your sample data seems to suggest you want to fill in rows, rather than column.

 

If that's the case, please find attached a solution using the Multi-Row Formula tool, otherwise, can you please clarify?

 

Hope this helps!

Giuseppe

 

 

amitsingh145
8 - Asteroid

Yes, it is column. 🙂

amitsingh145
8 - Asteroid

Hi, 

 

Problem is only in top few rows it is showing null. Other cells are blank.

 

Please see attached file.

 

Columns- Test,Day,Opponent,Ground.

 

Thanks

 

 

 

Ladarthure
14 - Magnetar
14 - Magnetar

hi @amitsingh145,

 

you can use my solution (second post) it solves the problem, the thing is that the isnull formula only check for null values whereas the isempty check for null or empty.

amitsingh145
8 - Asteroid

Hi,

 

It is still working for only those cells with null value.

 

Thanks

Ladarthure
14 - Magnetar
14 - Magnetar

could you send some sample data please (don't have the file here)

amitsingh145
8 - Asteroid

Alteryx file.

Ladarthure
14 - Magnetar
14 - Magnetar

in some cells when you put a browse, you will see a red mark, meaning there are spaces at the start or at the end, you can use a trim formula (trim([field]) to remove those uneeded spaces. and then use your multi row formulas.

 

Hope it helped!

Labels
Top Solution Authors