Iterate through datatable dynamically

Help
,
#1

Hi,

I have a requirement where I have to iterate in excel more times than actual rows are present. DtQuery.xlsx (9.8 KB) . So, Normally if we iterate through excel, it will iterate exactly the number of rows which are present. but as I have to iterate dynamically it will be more than the number of rows present. It’s count will be sum of L and M columns in attached excel. I have taken the count of both the columns and added them. But not getting any idea how to use that for iteration. Please help. Thanks!

#2

So you will filter before and remove all rows that are empty in cols L or M.

#3

Thank you for your reply.

I tried that but still, when I try to take the count of datatable it is giving the count of the column with the least rows as count of datatable.

#4

@shubhamg830
can you requirement be understood in that way:

  • iterate over each row
  • repeat an action for the current looped X times (and X is dynamic / specific for each row)
#5

yes, that’s right. The X times will be the sum of the count of L and M columns in the above attached excel.

#6

@shubhamg830
find a protoype here:
Demo Data:
grafik

Flow:

grafik
grafik555×588 36.3 KB

Log:
grafik

find starter help here:
LoopDR_RepeatDynamic_ActionForDR.xaml (8.2 KB)

#7

Thank you very much for helping me out. The requirement is slightly different.Capture . In the attached datatable screenshot, there are two columns and we have to iterate depending on the number of cells in it. Here, it will iterate 6 times as we have “A”, “B”, “C”, “3”, “5”, “2” as values in these columns. If we only had “A”, “B”, “C”, “3”, “5”, than it would iterate 5 times. Can you please help me with that. Thanks.

#8

Sure we will help you

I did not understand the example

The prototype was created with the intention to show case some buildings block doing iterations
May we ask you on following:

  • add a second DataColumn (as you had mentioned L,M col)
  • fill in some sample values
  • describe us expected behaviour like
    • row 0: do this calucation …, do that execution …

this will help us to finalizing and solving your case.
Thanks

#9

Sure, Here is the screenshot from the excel.

Iteration
Iteration1324×245 8 KB
. So Normally if i will use a for each row to iterate through this excel, it will run 3 times as there are 3 rows in the excel.

But in my requirement, I want it to run as sum of L and M columns, As in the attached screenshot, sum of count of both columns is 6, so it should run 6 times.
In 2nd screenshot

iteration2
iteration21330×215 7.88 KB
sum of count of L and M columns is 5, so the loop should run 5 times. Inside the loop there is some data entry which needs to be done on a website.
Sincere apologies if I am not able to articulate the issue well.

#10

@shubhamg830
it looks like you want to count the values from a column, where the values are not null or empty:

Do it like this for L column:
grafik
dtData.AsEnumerable.Where(Function (x) Not ( isNothing(x(LColNameOrIndex)) OrElse String.IsNullOrWhiteSpace(x(LColNameOrIndex).toString.Trim))).Count

Simialr do it for M coll. Sumup the counts and use it in the
Enumerable.Range(0,MySummedUpCountInteger)

#11

It’s working. Thank you for the help. Much appreciated.

#12

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