How to iterate datatables from a dataset using foreach?

[gh11 (Gowtham)]

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?

[Pavanraj_Shetty]

Hi @gh11

You can use this activity to loop through the data table

Hope this might help you

[ushu (Usha kiranmai)]

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

Assume test is dataset

[arjunshenoy]

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.

[gh11 (Gowtham)]

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

[ushu (Usha kiranmai)]

@gh11

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

@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)

[Pavanraj_Shetty]

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.

[gh11 (Gowtham)]

Thank you for the help @ushu