I need help with my situation.
Let say I have the dataset below:
and I need to paste it in a web application that only accept maximum of 20 entries per transaction.
as you can see I have 23 entries. I want to paste all of it using for loop.
I know I can do it using the for loop. but how can I formulate the logic for that?
is there an easy way to achieve this outcome?
since its in a loop
lets say for each row in DT
put a if condition
hope this helps
Hello @alvin.c.apostol26 ,
You can pick only 20 records per transaction by using the below logic :
Initially initialize counter to 0
dt_Output = dt_Input.AsEnumerable().Skip(Counter_value).Take(counter_value+20).CopyToDataTable()
after the expression initialize counter to :
Counter_Value = Counter_value+(dt_Output.Rows.Count)
in for each row activity there will be the property name called maximum iteration, there you can mention 20 or as your need
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.