Nested iteration in loop

Help
,
1

i have attached excel file which includes input and desired New Microsoft Excel Worksheet.xlsx (14.7 KB) output excel sheet.

2

Hi @nishant48
I can’t get you.
Could elaborate the scenario?

3

@nishant48,

Both the sheets looks same, there is no difference.

Could you elaborate the issue?

4

Hi Arvind,

i have to rearrange the rows from the input sheet according to Column Employee_GEID present in Manager_GEID. Suppose after Filtering 1046702 in Manager_GEID we get two employee 1051574 and 1303383.Now i have filter 1051574 in Manager_GEID Column we get 1034344 nd now again filter this in manager_geid column until there is no match of the employee_GEID in Manager_GEID Column.
Same Process should Repeat for 1303383 until the end.

5

Hi sarthi,

i have to rearrange the rows from the input sheet according to Column Employee_GEID present in Manager_GEID. Suppose after Filtering 1046702 in Manager_GEID we get two employee 1051574 and 1303383.Now i have filter 1051574 in Manager_GEID Column we get 1034344 nd now again filter this in manager_geid column until there is no match of the employee_GEID in Manager_GEID Column.
Same Process should Repeat for 1303383 until the end.
hope i have elaborated the issue…

6

@nishant48
Once u filter and have done with all your operations in datatable, finally rearrange the columns in datatatable.
Check this thread

Hope it helps.:slight_smile: