So this is probably a dumb question with an obvious answer, but I can't get the remove by value operation working. I have a collection with a number of entries that simply say "None". I want to remove them, but I can't seem to make it work. Help would be appreciated.
Have you tried remove duplicates first
and then remove "None"
I just tried remove duplicates and that didn't even remove the duplicates. I must be doing something wrong here, I just don't know what.
have you output your collection anywhere? do you know what is in it?
Later in the workflow I use build string from that collection, then set a field to that string. I can see what is in it through that.
some screenshots may help here
Sure. Here are some that might be helpful.
The query where I output to the collection:
The collection operation:
And the output:
Looks to me like your Collection has line breaks in each value
So each one is:
"None
"
rather than "None"
Can you clarify in the source?
The source does not have line breaks. I did go ahead and try the
"None
"
but it didn't work either.
How do you fill this collection with its values - ie do you query a list? Are you able to "trim" the values prior to putting them into the collection. I suspect it is the whitespace following these, whereas value must match exactly.
Yes, I'm querying the list to populate the collection. I've double checked the source and there are no extra spaces or line breaks in the data. I have tried removing the duplicates, but that doesn't work either.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.