Alternative way to bypass fields that is not always present

[Belletmns]

Hi Team,

Need your help, my data has a field that is not present all the time. Is there a tool or formula that would by pass that step if ever the field is not present? I would want to bypass formula tool if ever the field is not there.

Thank you

[Emil_Kos]

Hi,

I am not sure if this is what you are looking for but you can alternatively add this column using union tool just before the formula tool.

Thanks to that you will not get an error. 

Maybe others will propose better solution but I don't think there is a formula that will solve your problem. 

[atcodedog05 · Accepted solution]

Hi @Belletmns 

Here is what you can do, you can have header template so that column comes into your data even if its missing.

And if the column is missing then the value will be null or else it will have some value.

Formula on D is only applied if its not null (i,e it exits)

You can do the same with your data.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Belletmns]

@atcodedog05 Thank you for the idea!

[atcodedog05]

Happy to help 🙂 @Belletmns 

Cheers and Happy Analyzing 😀

[allisonatx]

@Emil_Kos So simple and works perfectly, thank you for this idea!