Alteryx Designer Discussions

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

Multi-Row Formula

Neffri
8 - Asteroid

Hi,
I have a question regarding the Multi-Row tool.

 

IDName%Country
1A20US
2B30TW
3C50US
nullnullnullUS
nullnullnullUS

Where I have nulls I want to take row-1.
Do you know if is it possible to do this not one by one(ID, Name,%).
In my real task I have ~8 column so I would like to avoid writing formula for each of them.

 

6 REPLIES 6
atcodedog05
21 - Polaris

Hi @Neffri 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1628585803507.png

 

1. Use transpose to convert columns to rows.

2. Apply mutli-row formula fill with groupby name (column name)

3. Convert it back to table using crosstab using record id as key.

 

Hope this helps : )

mceleavey
16 - Nebula

Hi @Neffri ,

 

I wrote a tool to do this. See attached.

 

Hope this helps,

 

M.

Neffri
8 - Asteroid

Thank you !!!

atcodedog05
21 - Polaris

Happy to help : ) @Neffri 

Cheers and have a nice day!

mceleavey
16 - Nebula

Cheers @atcodedog05 for pointing out a minor bug. That tool uses a Crosstab, which of course loses special characters in the column title. I've fixed this now.

 

M.

mceleavey
16 - Nebula

no problem.gif

Labels