Alteryx Designer Desktop Discussions

Wynn · ‎01-23-2020

Hello,

I'm interested in learning in if anyone can help me create a macro to move an entire row up by one row within the attached workbook. I have no experience in building a macro so this task is quite challenging for me. Basically, the workbook "Entity 1" is the original data that requires some cleanups. What I'm trying to do is move the entire row starting on row B19: U19 to C18. Please see the attached workbook " Result" - this illustrates what I wanted the workflow would generate something like this.

I actually was able to use the Multi row Formula tool to move the row to a specific cell. However, there are way too many columns in the "Entity 1" and this was not efficient and too manual to write down the code for each "Multi row Formula" tool . I'm wondering if anyone can help me build a macro in which I only need to use the Multi row Formula once and the workflow would repeat the same process until done. Thank you so much in advance!

BrandonB · ‎01-23-2020

I think that I was able to tackle this by moving the values from the first two columns rather than the other way around which would have needed formulas for all of the other columns. Take a look at the workflow attached and let me know if it solves your problem!

Wynn · ‎01-24-2020

Hi Brandon! Thanks for your attempt! That's great. I actually thought of creating a workflow like this as well. However, I guess my main point in this discussion is to learn more about building a macro in Alteryx. I was just thinking of a scenario in which I may not have only two columns to move down but a handful of columns , then what would be a good solution to this case? I'm interested in learning some sort of macros specifically built for this problem so that I can apply that going forward. Thanks for your try! It is an awesome workflow.

Wynn · ‎01-24-2020

@BrandonB forgot to mention you in the first reply.

BrandonB · ‎01-24-2020

@Wynn macros can be very useful I just didn't think it was the most effective for this exercise. Even with more columns, I probably would have taken a transpose, formula, then crosstab back approach.