Add new data row

[EvansM]

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 

[VianneyM]

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

[EvansM]

Attached Is the output example.

Thanks

[VianneyM]

hi @EvansM,

I have created this workflow. Let me know if the result is what you are looking for

Best,

Vianney

[EvansM]

Thanks but this  attached excel it he output I was expected. 

[VianneyM]

hi @EvansM,

attached the workflow to create one empty row

Let me know if this is what you need

Best,

Vianney

[EvansM]

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.

[RolandSchubert]

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

[VianneyM · Accepted solution]

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