You’re offline. This is a read only version of the page.
22
Hi,
I have been able to extract a table of values from webpage. I need to create a variable from this extract of one of the values from the table.
In the below table, I need to create a variable with the respective Job# from the report name containing the world "colonial".
So in the below instance, I need Job# J219350 to be its own variable that I can use further in my flow.
Any ideas how I can do this?
This is an example data table processing. Copy code below and paste it in your PAD.
Share
Report
All responses (
Answers (
SET DT_Report TO { ^['Job#', 'Operator', 'Report Name'] }
SET Job TO $'''J219354'''
SET Operator TO $'''RPA237'''
SET ReportName TO $'''CREATE COLONIAL ELIGIBILITY FILES'''
SET DT_Report TO DT_Report + [Job, Operator, ReportName]
SET Job TO $'''J219355'''
SET Operator TO $'''RPA238'''
SET ReportName TO $'''CREATE DUMP REPORT'''
SET DT_Report TO DT_Report + [Job, Operator, ReportName]
LOOP FOREACH CI_Report IN DT_Report
IF Contains(CI_Report['Report Name'], $'''colonial''', True) THEN
SET JobId TO CI_Report['Job#']
Display.ShowMessageDialog.ShowMessage Title: $'''RECORD CONTAIN COLONIAL''' Message: $'''Job : %CI_Report['Job#']%
Operator: %CI_Report['Operator']%
Report Name : %CI_Report['Report Name']%''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: True ButtonPressed=> ButtonPressed
END
END
