Robotic Process Automation (RPA)

 View Only
  • 1.  Filter Table

    Posted Mon March 20, 2023 10:12 AM

    Hi I am trying to filter a table to certain rows

    But I keep getting an error?

    filterTable --where "New Ship = \'Y\'" --dataTable ${ShpsSimpleTable} SimNewShips=value SimNewRows=rows SimNewColumns=columns



    ------------------------------
    Thomas Weston
    ------------------------------


  • 2.  RE: Filter Table

    Posted Mon March 20, 2023 10:16 AM

    Hello, Thomas. Can you send the error message?



    ------------------------------
    Giulianele Alves Barbosa
    ------------------------------



  • 3.  RE: Filter Table

    Posted Mon March 20, 2023 10:49 AM

    Here you go Giulianele

    3/20/2023 2:11:14 PM - Error executing command at line 50: filterTable --where "New Ship = \'Y\'" --dataTable ${ShpsSimpleTable} SimNewShips=value SimNewRows=rows SimNewColumns=columns
        Syntax error: Missing operand after 'Ship' operator.



    ------------------------------
    Thomas Weston
    ------------------------------



  • 4.  RE: Filter Table

    Posted Mon March 20, 2023 11:10 AM

    Enclose the column name with square brackets like in [New Ship] = 'Y'

    It is because the column name has a blank space on it. Documentation has more details about https://www.ibm.com/docs/en/rpa/23.0?topic=table-filter#the-where-parameter



    ------------------------------
    Giulianele Alves Barbosa
    ------------------------------



  • 5.  RE: Filter Table

    Posted Mon March 20, 2023 12:24 PM

    Thank you Giulianele that worked!

    I must have tried every combination but that one:-)



    ------------------------------
    Thomas Weston
    ------------------------------