Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
22 - Nova
22 - Nova

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
17 - Castor
17 - Castor

Hi @Neffri ,

 

I wrote a tool to do this. See attached.

 

Hope this helps,

 

M.



Bulien

Neffri
8 - Asteroid

Thank you !!!

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Neffri 

Cheers and have a nice day!

mceleavey
17 - Castor
17 - Castor

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.



Bulien

mceleavey
17 - Castor
17 - Castor

no problem.gif



Bulien

Labels