Does anyone know if there is a simple way to simplify a Table without using a formula? I could create a new column in a Formula tool and put "if Store is null then Store ID".
But I wonder if there is another way to do this ?
That depends on how the data got that way to begin with. Are they from two different files or branches of the flow? You could just use a select to change the column name.
If the data comes in that way, you could split the data using nulls in the first column and a couple selects to remove the null columns and rename and union them back, but that seems a bit more complicated than just using a formula.
Could you please share the compete formula inside of REGEX_Replace ?