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?
Solved! Go to Solution.
Have you tried a text input with no records? Just the headers.
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.
@ArtApa this just came in super handy making an iterative macro. Amazing how these tips can hve far-reaching impacts.