Check if column exists and if not, create it with a formula

Hi,

Is there any way I can check a file to see if a column exists and if it's not there, create it with a formula. If it is in the data set then move on to the next part?

For example, I want a table with first name, last name and full name, if Full name is not in there (as in the below table), then create a column that concatenate first and last name:

ID	Firstname	Lastname
1	John	Adam
2	Megan	Brown
3	Jessie	Sitkoff

If the Full name is in the data set and there's not separated columns for first and last name, then do text to column or something to get the two columns firstname and last name.

Thank you!

Preparation

Accepted answers

BrandonB

I did something similar before with a text input and a union tool. You create a text input with the fields that you are checking for. Then union that with your file you are feeding in. After that you can use a formula tool that says:

In the formula we would select the "FullName" field

IIF(IsNull([FullName]),[FirstName]+" "+[LastName],[FullName])

What this will do is create a full name if the value is null and use what is in the FullName field if it already exists. Then you can use a filter tool where FullName is not null to get rid of the fields with null text input values that you unioned in.