Add column flags
Hi,
I have a table which will contain an unknown number of columns. For each of those columns, I would like to create an additional column with the suffix flag. Within the new flag column, I need to put a true or false depending on whether the original column has a value greater than 0.
I think a column list loop with a rule engine may work but can’t seem to work out the logic. Any help would be amazing!