For each row - loops more than once

Help
1

Hi, I have an excel with bunch of names. I would like to loop through it and use the name in it as a variable and continue with it. But mine loops for than once each.

2

@sangasangasanga it may be due to problem in workflow, check the workflow thoroughly once.

3

Is it the problem with the order. E.g i assign the variable then put through loop. Is it wrong?

4

@sangasangasanga did u use build datatable activity?

5

Nope. i used read range from excel

6

@sangasangasanga i am not sure what is the problem untill i check ur workflow.

In Between y u checking Server(i,e datatable variable) is empty u should serverName if i am correct.

7

pls check my workflow

sorry, i don’t get you

8

@sangasangasanga sorry i thought ur are checking serverName is null instead of server in if condition

9

@sangasangasanga Try using clear datatable activity end of if loop for tally datatable variable. which is shown in pic below.

image

U have used 2 build datatable activities in ur workflow. In those 2 activities first row is null, delete those rows, which removes spaces generated in excel between two append operation.

try this and let me know

1 Like
10

Hi it works. Thanks.

1 Like