Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

How to move data from one row and column, to another

Darko
5 - Atom

Hello,

 

i would like to ask if there's a tool or a formula to take data from one row and then move it to a different row and column? 

For example, i would like to take the data that's in column B, row 20 and move it to column C row 19.

A                    B                            C

250024000Other Liabilities       
 50-0000-0030435840716717,0012,8512,8543.864,00 

 

 

Any ideas on how to do that are highly appreciated.

 

Thank you,

DavidP
16 - Nebula
16 - Nebula

The multi-row formula can do this. Have a look at the example in the tool palette

 

DavidP_0-1596701318206.png

 

grazitti_sapna
15 - Aurora
15 - Aurora

Hi @Darko,

 

Based on a certain condition you can make use of the Multi-row formula to update the rows as per your requirement. You can also select the column that you want to update.

 

For more details on how to make use of multi-row formula please go through the below link:

https://community.alteryx.com/t5/Alteryx-Designer/Tool-Mastery-Multi-Row-Formula/ta-p/86603

 

Sapna Gupta
joshbennett
10 - Fireball

Hi @Darko - here is an example of a formula you can use in the Multi-Row Formula tool suggested by @DavidP that would achieve the desired result for your scenario. If you wanted to remove the value from the original record after transferring it to the new record, you could just use another Multi-Row Formula to clear it out.

 

DextersLaboratory_0-1596703260521.png

 

Hope that helps! Workflow attached for reference.

 

 

 

Darko
5 - Atom

That's really helpful, but i may have explained my problem poorly. I basically need to fill every empty space (there are several) in column C with data from column B +1 row.

 

So what i'd need is a formula that would work on the whole column C and not just for a certain row (19 in the example). 

joshbennett
10 - Fireball

@Darko 

 

In that case, you can just update the Multi-Row Formula expression to the following (but leaving everything else the same):

 

 

if isempty([C]) or isnull([C]) then [Row+1:B] else [C] endif

 

 

Let me know if that does the trick for you.

Labels