Alteryx - Bypass errors

[Zor]

I have a Alteryx workflow which process monthly data (Jan to Dec) and these are columns - I have formula for 12 months for calculating data and also summarize tool.

My issue is when I run this workflow with Feb file in which Jan column is missing. My formulas and summarize calculations gets an error and workflow dont process the file, the workaround I have to delete Jan formula in Formula and Summarize, only then it works. Having said that I have to delete all past months calculation to make it work.

Is there anyway where I dont have to delete my Formula/Summarize reference of past months which are missing from the current month file ?

[gawa]

hi @Zor 

If you have dynamic schema input, then transpose tool can be used.

First, transpose data into vertical shape, then field name will be always "Name" and "Value". 

With this, manipulate data by Formula tool or something, and you can refer to filed [Name] [Value] in expression editor. Then you never miss these filed unlike [Jan], [Feb].... depending on input data schema. 

Finally revert to horizontal shape by Cross-tab tool.