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.
+16
Have you tried remove duplicates first
and then remove "None"
+10
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.
+16
have you output your collection anywhere? do you know what is in it?
+10
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.
+16
some screenshots may help here
+10
Sure. Here are some that might be helpful.
The query where I output to the collection:
The collection operation:
And the output:
+16
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?
+10
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.
+10
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
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.