How to stop repetition of the row?

Help Activities
, ,
1

I’m using these activities
image
and i’m getting output as this

image
image1260×443 32.2 KB

where I see one row getting repeated at the top! can anyone help me solve this ?

2

Hi @Kancharla_Mahija

Can you share your workflow then we can understand your question or can you explain brief

3

@Kancharla_Mahija Disable write range activity and check

1 Like
4

@Kancharla_Mahija
use write range or append range inside for each row in datatable
if iteration is completed loop stop by itself

1 Like
5

Hi, why you use write range and append range both? use only one, disable or remove write range activity then run your workflow and check once.

6

First, you can identify the data for each row. When you add data, check if the data is already mentioned in the table. If it updates the existing row before adding the new one, could you ensure each row is distinct?

1 Like
7

Hello @Kancharla_Mahija
Try This
Use If Condition to find the file is exist or Not.
If Condition—> File.Exist(Environment.currentDirectory+"\Output\OutputExcel.xlsx")
Then —> Use Append Range Worrkbook.
Else —> Use Write range Work book.
After If condition place the Clera datatable and pass the “DTinuse” variable to clear the data in the variable.

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.