Adding a column conditionally

[carl-meyer]

Okay so I have my workflow running intended for one sample of data but when i run it for another it doesnt work because it is short one column. 

So on the other sample F6 doesnt exist and the data i want to be in F6 is in F5. I tried dynamically renaming the columns and using a blank text input with a union to insert a column but if i do that then the first sample has 7 rows of data. Is there anyway to say if F6 doesn't exist add a column somehow? 

[gabrielvilella]

Have you tried a text input with no records? Just the headers.

[ArtApa · Accepted solution]

Hi @carl-meyer - Please find attached idea. You can play and switch off/on "w/o F6" and "With F6" containers. The pink "Empty" container will do the job for you. Please see attached.

[logdog0411]

@ArtApa this just came in super handy making an iterative macro. Amazing how these tips can hve far-reaching impacts.