Hi all, building my own table from a number of others, and making a column that I want to have fixed length. If a column exists from another table, I wish to fill it with values made from a list , if not, i wish to fill it with zeroes. Currently, there are no values appearing and I cannot figure out a place to put the if statements that will make this work out. This is my most recent attempt, Idea is to fill with values from the array N_4, which is populated if that column name exists, else fill with zeroes, but I'm not sure if this is the correct way to do it, any pointers would be welcomed!
New Column( "N(4)",Numeric, formula(If( Contains( Data Table( "Counter Bin Summary" ) << get column names( string ), "N(4)" ) ,Values(N_4),Set Each Value (0)) )),