Good morning. I’ve been using the Filter Table activity which has been very useful however I’m finding some limitations with it.
I am currently filtering a table which contains entries similar to:
AB01
CG05
RD06
ET06
ZA01
LK04
In this case I only want to filter on the entries that end in ‘06’ and as the values can change when future runs of the workflow happen I cannot just list all the entries that contain ‘06’. Similarly there are a large number of entries within this column in the excel sheet and filtering on entries that end in ‘06’ is the easier and quicker way
I was also wondering for the sake of future UiPath rookies how would you go about including in Filter Options the entries you DON’T want included? An example being:
AC02
DE03
JW05
KL01
BN01
QA02
How would you include in Filter Options that you want to return all entries that DO NOT contain the letter ‘B’ in it?
I tried {“<>*B*”} which is how “does not contain” would be recorded in a macro but UIPath gives a range error. Maybe someone at UIpath can enlighten us.