Automating Data Extraction Wizard

Help StudioX
, , ,
1

Hi all,

I am having an issue with using the Data Extraction Wizard on a table that can potentially have a different number of columns on each use. I would like to fully automate the process and would like to avoid having to manually click through the Data Extraction Wizard to select each column in the table. The issue arises if say, for example, I have set up the wizard to extract all data from a table with 15 columns and I attempt to run the same sequence on a table that has 20 columns. In this scenario, some of the data would not be extracted.

Is there a good way to solve this problem? Is it possible to have the robot use the UiPath application prior to getting the data and automating clicking through the wizard?

If not, is there another possible solution? Thank you for all possible help!

2
  • extract the entire table
    OR
  • generate automated the extract metadata / extraction config
3

Hi @PurplePrognoses

If your query is when you are trying to extract the data it was not extracting some items, because it has 15 columns for first time and 20 columns in other time.

Try the below approach,
→ Use the Extract table data activity and indicate on the table, when you indicate on one row it will ask to extract all rows right, then check it to extract all rows.
→ Come back to studio and open the properties of Extract table data activity and copy and remove the selectors from fuzzy selector and paste those selectors in the strict selectors.

It will works in dynamic. Give a try with this approach.

Hope it helps!!

4

Thank you! Extracting the entire table was the best solution for my specific application.