Multirow formula

[KaterinaSimerdova]

Hello,

can you please help what to use as formula to down fill empty spaces?

We used below multi-column formula, but it is not working:

IIF IsEmpty([column2])
THEN [Row-1:column2]
ELSE [column2]
ENDIF

Multirow formula is not available in desktop version.

Thank you very much!

[davidskaife]

Hi @KaterinaSimerdova 

Not sure if it's a typo but the start of the formula needs to be IF not IIF

If (pardon the pun) that doesn't fix it can you post some more details? Whats the error message, what does your data look like etc

Also when you say Multirow formula not available in desktop version, what do you mean?

[KaterinaSimerdova]

Thank you, David, for quick reply!

I meant that Multirow formula is not available on CLOUD, not desktop...

Please find attached screen shot how it is not written - formula not working even with IF.

Thank you,

KS

[davidskaife]

@KaterinaSimerdova 

Ahh i see, Designer Cloud Native Tools don't have the Mutli-Row Formula tool...you're formula won't work as it won't recognise the Row-1 element.

The easiest option is to switch modes, you'll be in Cloud Native Mode but Standard Mode was released last year, which contains the Multi-row tool! https://community.alteryx.com/t5/Analytics/Introducing-Designer-Cloud-Standard-Mode/ba-p/1334661 however i cannot seem to see it from your screenshot, you may have to speak to your admins/Alteryx about enabling it.

If you can only use Cloud Native then I've had a quick look around the community and found this - https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Without-using-Multi-row-formul... there are two ways presented of doing it without the Multi-Row Formula tool, but they're both quite convoluted, especially if you're having to do it on a lot of columns.