Nested For loop never stops

Help
1

Hi

I used “read range” activity and created 2 data tables .
RAWDATA
STATUSDATA

i use followin logic

for each row in RAWDATA

…
… for ecch row2 in STATUSDATA

        if   row.somecolumnvalue = row2.somecolumnvalue

      next

next

Instead of stopping after 329 rows …it is running forever …?

image
image1440×900 68 KB

2

Main backup.xaml (21.6 KB)

3

Hi @allurai_india,

What is the expected result from these datatables?
why do you want loop ?

Thanks,

4

Hi @allurai_india,

May be the issue was with the link its is redirecting to the same sequence ,
i have highlighted in screenshot check by deleting the link.

image
image744×421 8.78 KB

1 Like
5

there is a commonn column called “Project status” in both the spread sheets .

I want to to kind VLOOKUP and the desisred columns in to OUPUT,XLs.

6

hi @allurai_india

Have you tried the lookup activity under data tables? Why not use that instead of looping?

Or else, You can use the Data Table Join activity to join the two data tables to find matching records. I believe these solutions are much efficient than having two loops

7

Sorry for that , I treied with that …but i need only 4 columns from both the spread sheet …
I am unable to find how to do it ?

image
image1440×900 72.6 KB
with DATAlookup approach.xaml (7.7 KB)

8

That is not a problem. Use the data table join first. And in the output data table, you can use the Remove Data Table Column activity to remove the unwanted columns so that it will contain only the columns you require to write to the excel.

9

thanks so much …you save my day …

I was nit sure …how it was RE DIRECTING.,all this time…

1 Like
10

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