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
250024000 | Other Liabilities | |||||||
50-0000-0030435 | 840 | 716 | 717,00 | 12,85 | 12,85 | 43.864,00 |
Any ideas on how to do that are highly appreciated.
Thank you,
Solved! Go to Solution.
The multi-row formula can do this. Have a look at the example in the tool palette
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
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.
Hope that helps! Workflow attached for reference.
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).
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.