Need help with Skipping columns if not there

Question

I am trying to create a standardized Workflow where let's say I have 4 columns (A,B,C, and D). Some companies have data in all 4 columns and some companies only have data in column B and D. How do I create a workflow that allows me to ignore and continue in the workflow if Column A and D are missing?  Because later in the workflow, I do have formulas using columns A and D but if the column is missing then an error occurs. So I am trying to figure out a way to skip those formulas and have the workflow continue without it breaking every time and without me having to create multiple workflows for specific companies. I want to be able to create one workflow that I can use for all companies.

Does that make sense?

Thanks in advance!

JPSeagull · Answer

The easiest solution is just add in a text input tool where you only have the column headers listed (order doesn't matter). Union it to your main data input and what happens is if the main data is missing a column, then the placeholder column from the text input will fill it in.

Felipe_Ribeir0 · Answer

Hi @gtruong

It seems to me that you just need to do something like this. If the header from the text input is on your cross tab, it will do nothing, if it is missing it will create a column.

FinnCharlton · Answer

Hi @gtruong , here is a way of ensuring all headers are present:

Ensure all header.yxmd