Nested Foreach Loop

Help Studio
, , , ,
1

Hi

I want to copy “Average of Hourly” and “Count of Traveller” data from “Sheet1” as DT1
Paste it in “NursingAllied”, Column “Current Rate Avg” and “Prior Rate Avg” as DT2

See the image Below…

The image shows two Excel workbooks side by side, with one displaying a pivot table of hourly rates and traveler counts, and the other a table set up to record current and prior rate averages, traveler totals, and prior week totals. (Captioned by AI)
The image shows two Excel workbooks side by side, with one displaying a pivot table of hourly rates and traveler counts, and the other a table set up to record current and prior rate averages, traveler totals, and prior week totals. (Captioned by AI)1022×769 49.1 KB

Her is my code

The image depicts a nested iteration workflow over two data tables, with a conditional statement inside the inner loop, followed by writing the output to a workbook. (Captioned by AI)
The image depicts a nested iteration workflow over two data tables, with a conditional statement inside the inner loop, followed by writing the output to a workbook. (Captioned by AI)475×697 19 KB

image

this it the Ouput after write range

**

The image shows a spreadsheet with columns labeled "Site," "Col1" through "Col13," and "Traveler Total," containing various monetary values all formatted in dollars. (Captioned by AI)
The image shows a spreadsheet with columns labeled "Site," "Col1" through "Col13," and "Traveler Total," containing various monetary values all formatted in dollars. (Captioned by AI)720×443 6.41 KB

**
I stuck here 3days now :frowning:
Any advice?

Thank you in advance…
-Vincent

2

if you have both the pivot excel in a dt and the nursing excel in a dt. Compare the row labels and site column if they match assign the data if they dont match break the inner loop using break activity. Like pivot make it the outer loop and nursing allied the inner loop

3

hi @muktadir do you have sample workflow?

4

Hi @Vincent_Nuestro

Which part exactly are you stuck on?

SampleVN.zip (16.2 KB)

Does this sample workflow help you? If so, check this link.

Cheers

Steve

5

hi @Steven_McKeering

Upon writing the report Outside the nested Loop

The problem now is only row1 is correct.

i dont Know what happened to the rest

The image shows two Excel sheets side by side with pivot tables displaying data related to hourly averages and counts of travelers/providers for various rows, with one of the sheets highlighting specific values in green and red. (Captioned by AI)
The image shows two Excel sheets side by side with pivot tables displaying data related to hourly averages and counts of travelers/providers for various rows, with one of the sheets highlighting specific values in green and red. (Captioned by AI)905×716 40.7 KB