Hi all, I hope someone to help me. I'm append my output in excel, but it is duplicating the lines. I would like to add just the new lines, and skip the previous lines. My example: DateSNTimeResultStatus10/jan/231A57004:02:1015,7Approved11/jan/2320B25105:25:1520,7Failed15/jan/2315C58903:10:3110,1Approved After appending: DateSNTimeResultStatus10/jan/231A57004:02:1015,7Approved11/jan/2320B25105:25:1520,7Failed15/jan/2315C58903:10:3110,1Approved10/jan/231A57004:02:1015,7Approved11/jan/2320B25105:25:1520,7Failed15/jan/2315C58903:10:3110,1Approved17/jan/2340B87007:10:5930,5Failed It is duplicating the lines 10/jan/23, 11/jan/23 and 15/jan/23, which all columns are the same. It is duplicating the data. My desired output would be this: DateSNTimeResultStatus10/jan/231A57004:02:1015,7Approved11/jan/2320B25105:25:1520,7Failed15/jan/2315C58903:10:3110,1Approved17/jan/2340B87007:10:5930,5Failed I just would like to add the different lines (comparing all columns). Does anyone knows how to do this? Many thanks, Wilson

How to append without duplicating the lines

Hi all,

I hope someone to help me.

I'm append my output in excel, but it is duplicating the lines. I would like to add just the new lines, and skip the previous lines.

My example:

Date	SN	Time	Result	Status
10/jan/23	1A570	04:02:10	15,7	Approved
11/jan/23	20B251	05:25:15	20,7	Failed
15/jan/23	15C589	03:10:31	10,1	Approved

After appending:

Date	SN	Time	Result	Status
10/jan/23	1A570	04:02:10	15,7	Approved
11/jan/23	20B251	05:25:15	20,7	Failed
15/jan/23	15C589	03:10:31	10,1	Approved
10/jan/23	1A570	04:02:10	15,7	Approved
11/jan/23	20B251	05:25:15	20,7	Failed
15/jan/23	15C589	03:10:31	10,1	Approved
17/jan/23	40B870	07:10:59	30,5	Failed

It is duplicating the lines 10/jan/23, 11/jan/23 and 15/jan/23, which all columns are the same. It is duplicating the data.

My desired output would be this:

Date	SN	Time	Result	Status
10/jan/23	1A570	04:02:10	15,7	Approved
11/jan/23	20B251	05:25:15	20,7	Failed
15/jan/23	15C589	03:10:31	10,1	Approved
17/jan/23	40B870	07:10:59	30,5	Failed

I just would like to add the different lines (comparing all columns).

Does anyone knows how to do this?

Many thanks,

Wilson

Developer

Developer Tools

Accepted answers

atcodedog05

Hi @WBCamargo

The only possible way I can see is

1. You read the data from the existing output file and append it with the new output rows (i,e performing append in the workflow instead of the output tool append option).

2. It is suggestible to use the record id tool before in case you want to maintain the order. For existing data start the record id from 1 and for new data start the record id 10000 or so a high number so that it always comes below existing data.