RPA BOT moving to next record in Table in Workday

Skipping Records in a Loop – Workday Report Processing

Understanding the Pattern

The core concept is to use conditional logic (If/Else) inside your loop to evaluate whether a record should be processed or skipped, combined with AA's Loop: Continue action (equivalent to a continue statement in programming — it skips the rest of the current iteration and moves to the next record).

Recommended Approach: Using Loop: Continue

This is the cleanest and most recommended method in Automation 360.

Basic Structure:

Loop (Counter: 1 to TotalRecords)
│
├── [Get current record data from Workday / DataTable]
│
├── If (condition to SKIP this record is TRUE)
│   └── Loop: Continue   ← Skips to next iteration immediately
│
└── [Process the record normally if not skipped]
    ├── Step 1...
    ├── Step 2...
    └── Step 3...

How it works:

The Loop: Continue action tells AA to immediately jump to the next iteration of the loop, skipping all remaining actions below it in the current iteration.

This is available in Automation 360 under: Loop package → Continue

Common Skip Conditions for Workday Reports

Here are typical conditions you might want to skip a record on:

Full Implementation Pattern

Step 1: Load the Workday Report into a DataTable

// Option A: If exported as CSV/Excel from Workday
Excel: Open Workbook → Read All Rows → Store in DataTable variable ($WorkdayData$)

// Option B: If using Workday Web UI scraping
Loop through Workday report pages → Extract data → Store in DataTable

Step 2: Get Total Record Count

DataTable: Get Total Rows → Store in Number variable ($TotalRecords$)

Step 3: Loop with Skip Logic

Loop: Iterator (Counter from 0 to $TotalRecords$ - 1)
│   [Counter variable: $RowIndex$]
│
├── DataTable: Get Cell → Row: $RowIndex$, Column: "Status"
│   → Store in String variable ($RecordStatus$)
│
├── DataTable: Get Cell → Row: $RowIndex$, Column: "EmployeeID"
│   → Store in String variable ($EmployeeID$)
│
├── // ─── SKIP CONDITIONS ───
│
├── If ($RecordStatus$ = "Cancelled")
│   └── Loop: Continue
│
├── If ($EmployeeID$ = "")
│   └── Loop: Continue
│
├── If ($RecordStatus$ = "Processed")
│   └── Loop: Continue
│
└── // ─── PROCESS THE RECORD ───
    ├── [Navigate to Workday transfer screen]
    ├── [Fill in transfer details]
    ├── [Submit / Save]
    └── [Log success to output file]

Enhanced Pattern: With Logging and Error Handling

For production-grade automation, add logging for skipped records:

Loop: Iterator (Counter from 0 to $TotalRecords$ - 1)
│
├── Get record data → $RecordStatus$, $EmployeeID$, $TransferType$
│
├── If ($RecordStatus$ = "Cancelled" OR $EmployeeID$ = "")
│   ├── // Log the skipped record
│   ├── String: Append → "$EmployeeID$ skipped – Reason: $RecordStatus$"
│   ├── Log to File (SkippedRecords.csv)
│   └── Loop: Continue   ← Skip to next record
│
├── Try
│   ├── [Process the transfer in Workday]
│   └── [Log success]
│
└── Catch (on error)
    ├── [Log failure with record details]
    └── Loop: Continue   ← Skip failed record, don't stop entire bot

Tracking Counts (Processed / Skipped / Failed)

Add counter variables to track outcomes for reporting:

// Initialize before loop
Number: Assign → $ProcessedCount$ = 0
Number: Assign → $SkippedCount$ = 0
Number: Assign → $FailedCount$ = 0

// Inside loop - on skip:
Number: Increment → $SkippedCount$
Loop: Continue

// Inside loop - on success:
Number: Increment → $ProcessedCount$

// Inside loop - on failure:
Number: Increment → $FailedCount$

// After loop - summary:
Message Box: "Processed: $ProcessedCount$ | Skipped: $SkippedCount$ | Failed: $FailedCount$"

Key Tips for Workday Report Processing

Important: Loop: Continue vs Loop: Exit

Always use Loop: Continue for skipping individual records.

References

• AA Loop Package Docs: https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/loop-package.html
• AA DataTable Package: https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/data-table-package.html

Thank you for information