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
Solved! Go to Solution.
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
@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: