Hello,
I have a workflow where the output tool is writing an excel file. But in the file column CN values is split with column CP.
Please see the attached image for reference.
Is there a way I can resolve this?
Thank you.
Hi @Pankhudri20 ,
Are you writing to xlsx or to csv in your workflow? Could you share a screenshot of your output data tool configuration?
Hello @kelsey_kincaid
I am writing to a csv file.
Without seeing your workflow, it's a little hard to guess, but you might just need a Join instead of a Union tool. See the attached.
Hi @DanH
Please find the screenshot of a part of workflow attached.
Unfortunately, i cannot share the workflow here.
Which union should I remove U1 or U2?
Thank you!
Hello @Pankhudri20 ,
The problems seems to be most likely to the column being renamed by a join tool.
Setting up an example, if on the first join (the upper one) shares the name of a column on both sides (L and R) the 'R' one will be renamed (To Right_A).
If you then join the data again on the bottom join it may be that you are getting the column Right_A from the left data and A from the right data.
Check the name on both columns, it is most likely due this that you are getting the results on two separate columns.
Regards
