How to iterate datatables from a dataset using foreach?

Help Studio
, ,
1

Previous version of For each had TypeArgument property thorough which we can select system.data.datatable. Now in 2023.4.0 version, there is no properties available in foreach. How can we use the foreach to iterate the tables?

2

Hi @gh11

You can use this activity to loop through the data table

image

Hope this might help you :slightly_smiling_face:

3

Hi @gh11 - Take for each activity, provide your datasetname.Tables.

Assume test is dataset

Picture1
Picture1618×524 12.3 KB

1 Like
4

Hi @gh11

After the latest update, in 2023.4.0 version, you will get no option to select TypeArgument manually. Studio will automatically detect the type of data you are iterating through, right at the moment you enter the data.

Hope this helps,
Best Regards.

5

Screenshot (115)
Screenshot (115)830×619 18.7 KB

I’m getting error while assigning the currentitem in Output datatable or WriteRanges.

6

@gh11 - Can you try this way

  • Go to properties of For Each and assign variable for Index
  • Within the loop, in the Output data table, pass test.Tables(Index)

Picture1
Picture1903×538 46.8 KB

7

Hi @gh11
You can’t place currentitem to the Output data table or WriteRanges. It should be in the form of the data table

Cheers.

8

Thank you for the help @ushu

9

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