Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Table fields

  • Updated: 5/07/2020

    Table fields

    Add scripts in Designer for table fields.

    Procedure

    1. In IQ Bot Designer, left-hand panel, highlight Table/section settings for the table whose extraction/validation you aim to improve further.
    2. In the middle panel, scroll down to Logic.
    3. In the Logic section, toggle between fullscreen and smallscreen for ease of use.
    4. Add code to modify the extracted table values, which are stored as a Python dictionary in a user variable called table_values. See example below.
      Each row has a Guid (Global unique identifier), which allows IQ Bot to auto track rows that are added and deleted. If you add a row, you need not enter a Guid. IQ Bot will handle this automatically.
      
      # variable that stores the value: table_values
      
      # convert from dictionary to dataframe
      df = pd.DataFrame.from_dict(table_values)
      
      # print dataframe before update
      print(df)
      
      # Item_Description: drop rows with a missing value
      df = df[(df["Item_Description"] != "")]
      
      # Quantity: extract first part of the string, the numeric part only
      df['Quantity'] = df['Quantity'].str.split(' ', 1).str[0].str.strip()
      
      # print dataframe after update
      print(df)
      
      # convert back from dataframe to dict to override what IQ Bot stores
      table_values = df.to_dict()
      
    5. Select Test Run to test your script and see the results before vs. after.
      
            Item_Description                                  Guid         product_id     Quantity Item_Total
      0         wafer, NO172  43ea78f4-7b9b-413a-83ce-89d671478d6c  2 COMS5A-18090220     4.00 PCS   5,840.00
      1  Visual Iaspection +  cc774f5f-2507-4a15-8e45-7b2abf84fabe                         1.00 EA      65.00
      2                       6bddfed1-2359-4305-a0ac-a1769c113bfb   5% VAT : Total -  4.00PCS GR:   5,905.00
      3                       2dc642a7-8e6e-4bc6-9672-85afff8c21db            Total -         KGD:       0.00
      
      
      
            Item_Description                                  Guid         product_id     Quantity Item_Total
      0         wafer, NO172  43ea78f4-7b9b-413a-83ce-89d671478d6c  2 COMS5A-18090220     4.00       5,840.00
      1  Visual Iaspection +  cc774f5f-2507-4a15-8e45-7b2abf84fabe                        1.00          65.00
      
      
    6. If you select See extraction results or save the bot, your script is saved.
    Send Feedback