Hello Community,
Please refer attached excel worksheets. I need help to add new data row. I am not sure what kind of tool I should use to achieve this task.
Note:NOTES2.xlsx is EXPECTED RESULT(output)
Thanks
Solved! Go to Solution.
Hi @EvansM,
where exactly do you want to add the new data row? do you have an example of how your output should look like?
Best,
Vianney
hi @EvansM,
I have created this workflow. Let me know if the result is what you are looking for
Best,
Vianney
hi @EvansM,
attached the workflow to create one empty row
Let me know if this is what you need
Best,
Vianney
No that is not the results I was expected. There two excel worksheets (NOTES & NOTES2)
1.NOTE.xlsx: Is the problem I am trying to solve.
2.NOTE2.xlxs: Is the Expected results (OUTPUT).
I think what you did you added all the worksheet together. By doing that I am not getting the results I wanted.
Thanks.
Hi @EvansM ,
in my understanding, you want to create new rows for the rows having an entry in "CATEXT4".
It should be solved by the attached workflow:
Best,
Roland
Hi @EvansM,
I think now I understand what you need. It was a bit confusing with the output within the input. I thought you want to extract it from there.
I have reworked the workflow. Keep in mind that I have changed the initial input tool configuration (in case you replace your input data source, make sure you don't replace the configuration)
Input
Output
Let me know if you have any questions
Best,
Vianney