Editing java Snippet node to check if column exist or create it

[ipazin]

Hello @tommasopalomba,

check here:

Check if Column Exists in Column Expressions Node

Hello, I have a column that exists within some files and not in others. Thus, when running a loop through reading all the files, it does not always appear. I am running into a problem with the Column expressions node that it throws an error because the column I am wanting to use (if it exists) does not exist. Essentially, I want to write an expression that says: If the column(“column1”) exists, then do something, else, do something different I have tried something along the lines of with no …

Also check this topic by using Table Validator node(s):

Add column if doesn't exist

Hi @TigerCole yes 5 years later there are better solutions for this I would now use the Table Validator for this. You can in the dialog define what happens if certain columns are missing, and add them with Missing Values in case they are not there. The Missing Value can than add you a fixed value into these missing values. [image] If you have a second reference table, you can also use the Table Validator (Reference) Than you do not have to take care of configuring the node…

Br,
Ivan