cancel
Showing results for 
Search instead for 
Did you mean: 

Need help with the Filter on Collection where I need the Collection column to be on the right

Tak.Kwok
Level 4

Hi:

Need help with the Filter on Collection where I need the Collection column to be on the right (Normal is for the column name to be on the left hand side). For example: Collection is call Keywords and the column needed to be search if it contains the string is named Keywords ( I needed to have it that says something like "Folder Name" Like '*keywords*'. I tried the attached screen shot but it was giving me an error msg: Could not execute code stage because exception thrown by code stage: Cannot interpret token '"' at position 28. I know you can loop through the collection to do an Instring but that will take a long time to loop through. So was hoping to use filter as it will be faster. Appreciate if anyone is able to let me know if the filter collecton will work in this case. 

 

TakKwok_0-1754595928219.png

 

2 REPLIES 2

Hi @Tak.Kwok 

Can you also share the screenshot of collection?

Best Regards,
Sayeed Bin Abdullah

Hi @Tak.Kwok,

Could you please try the following expression in the Filter property: "[Last Folder] like '%" &[Keywords2.Keywords]& "%'"

If it doesn't work, please share the screenshots and more details as mentioned by Sayeed above.

Best regards,
Sourav S
Consultant - Automation Developer
WonderBotz