I find the belwo workflow which work great - however I would like to order header based on the number of now empty row. can anyone help?
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Remove-NULL-Columns-2019-4/m-p/755533/highlight/false
Remove null - works great ! original flow attached
Target - keep ordering after dynamic rename
Hi @MI1
Add filter tool here. This method is processing more records hence is bit more slow.
Hope this helps : )
Here is how you can do it.Workflow:
@atcodedog05 The filter remove null column seems not working ? as I still get some null column in the flow ?
Hence I put a filter after however not sure it is the optimum solution? as the process is relatively "Slow" now