topic Need a efficient way to load web table data into collection in Product Forum

Need a efficient way to load web table data into collection

ZhimingLiu — Wed, 28 Oct 2020 09:56:00 GMT

Is there any way to load table data into a collection in a efficient way?

------------------------------
Zhiming Liu
------------------------------

RE: Need a efficient way to load web table data into collection

GopalBhaire — Wed, 28 Oct 2020 13:10:00 GMT

Hi,

Is this a web application? If yes you can spy the whole table and use read items to get data in collection.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Need a efficient way to load web table data into collection

krista.m.james — Thu, 29 Oct 2020 13:58:00 GMT

I recently learned that you can also spy one field of the table, then in your 'Read' stage for that 'Element' choose the Data option 'Get Table'. It brings the table (and possibly some blank columns and rows) into a collection. I happened to use this in SAP Ariba, but the poster I learned it from didn't say what they were using.

------------------------------
Krista James
Solution Designer
The Boeing Company OIG&A
America/Los_Angeles
------------------------------

RE: Need a efficient way to load web table data into collection

NileshJadhavBP — Fri, 30 Oct 2020 16:32:00 GMT

Great 🙂

You can use remove blank row action to remove blank from collection.

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------