This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
While I would normally use the Transpose tool for something like this, I'm not sure that you're guaranteed to keep column C after column B as you are wanting.
As an alternative, I would suggest using two Select tools from your Input. One will keep Col A and Col B and the other one will keep Col A and Col C. Then just use a Union tool and choose Auto Config by Position and set the output order. See the sample workflow attached.
sorry I mean exactly what you had done in the workflow earlier, except this hasn't happened on my workflow as I still have separate columns. in the top select I have ticked col a and col b, in the bottom select I have ticked col a and col c, and then in the union I have done what you have said. except I still have col a b and c
@mlp Double check that you have selected "Auto Config by Position" at the top of the configuration of your Union tool. Then, to ensure you get them in the correct order, set the output order depending on the order you connected the tools (i.e. which stream is #1 and which is #2). See the pink circles below.