07-08-25 08:53 PM
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.
09-08-25 05:01 AM
11-08-25 12:02 PM - edited 11-08-25 12:15 PM
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.