Applying Multi-Row formula to all Coulmns at once instead of using one tool for each Col

Question

Hi All,

I wish to know if there is way we can apply below multi-row formula to all columns at once rather than using one multi-row formula tool for one column which becomes tedious and time consuimg if there are large number of columns in your data.

IF isempty([ColA]) THEN [Row-1:ColA] ELSE [ColA] ENDIF

Any thoughts or sugesstions?

IraWatt · Accepted Answer

Hey @Tej_Singh,

To apply a multi row formula to multiple rows you just need to transpose your data first using the transpose tool then group by the column names in your multi row formula tool, example attached:

This solution uses the transpose tool which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com