Thank you Giulianele that worked!
I must have tried every combination but that one:-)
------------------------------
Thomas Weston
------------------------------
Original Message:
Sent: Mon March 20, 2023 11:09 AM
From: Giulianele Alves Barbosa
Subject: Filter Table
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
Original Message:
Sent: Mon March 20, 2023 10:48 AM
From: Thomas Weston
Subject: Filter Table
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
Original Message:
Sent: Mon March 20, 2023 10:15 AM
From: Giulianele Alves Barbosa
Subject: Filter Table
Hello, Thomas. Can you send the error message?
------------------------------
Giulianele Alves Barbosa
Original Message:
Sent: Mon March 20, 2023 10:12 AM
From: Thomas Weston
Subject: Filter Table
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
------------------------------