Hello Folks, I am an 3 day old RPA-UiPath learner. I was Assigne a task to import data from excel into a portal , enter the Customer Code, Item Cod and Quantity in the portal columns and Capture the Confirmation Id, writing it back into the same input exc

Help Studio
1

Hello Folks, I am an 3 day old RPA-UiPath learner. I was Assigned a task to import data from excel into a portal , enter the Customer Code, Item Cod and Quantity in the portal columns and Capture the Confirmation Id, writing it back into the same input excel creating different row for confirmation ID

The workflow is successfully executes until login into the portal but cannot able to read the data from excel .

Assign PreviousStoreCode = “” // Initialize PreviousStoreCode
For Each row In YourDataTable // Iterate through rows
Assign CurrentStoreCode = row(“StoreCode”).ToString() // Get CurrentStoreCode

// Check if it's the first row
If row.Equals(YourDataTable.Rows(0))  // Assuming you're working with a zero-based index
    Search CurrentStoreCode
    Search ItemCode
    Add Quantity
Else
    // Check if CurrentStoreCode matches PreviousStoreCode
    If CurrentStoreCode = PreviousStoreCode
        Search ItemCode
        Add Quantity
    Else
        // Check if CurrentStoreCode differs from PreviousStoreCode (and not the first row)
        Submit Order for PreviousStoreCode
        Capture Confirmation Code
        Write "Calculation performed successfully" in Excel

        Search CurrentStoreCode
        Search ItemCode
        Add Quantity
    End If
End If

// Check if it's the last row
If row.Equals(YourDataTable.Rows(YourDataTable.Rows.Count - 1))
    Submit Order
    Capture Confirmation Code
    Write Confirmation Code in Excel
End If

Assign PreviousStoreCode = CurrentStoreCode  // Update PreviousStoreCode

End For

2

I suggest starting here.