Fill down Field Header as values in multiple rows

Question

Hi

I am new to Alteryx. I have a field name and I want to fill down the field name as multiple rows of data in the same column. I am trying the multi-row formula if Isempty([Data from month of September])then [Row-1:Data from month of September]else [Data from month of September]endif

I am not getting any output, Any suggestions?

thanks,

srz

IraWatt · Accepted Answer

Hey @sraizada,

One way to get your field names as a row of data you can use is with the field info tool then pivoting it so you can union it on top of your data. Then you can use your formula:

This solution uses the cross tab 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

DataNath · Accepted Answer

@sraizada are these empty fields that you just want to populate with the field name? If so, can just reference the field name in a Multi-field Formula like so: