Sort and filter an collection an copy results to a new collection

[klausbergh]

Hi

I had tried almost i think, but i can't figure out to do the following

I have a collection with 3 columns. What i want is to search each row in country column, and get the rows that match ex "dk" in this. These rows should be copied to another collection

Can anyone give me a clue about how to proceed

[devneetmohanty07]

Hi Klaus,

The easiest approach is to go with a pre-built action called "Filter Collection" from "Utility - Collection Manipulation". You need to provide the Input Collection having the county column and then you can write a simple filter query like: "[County Column Name] = 'DK'" and store the output of this action in an Output Collection.

You can refer to the below workflow for more details:



Input Collection:



Filter Action Used:



Output Collection:




Please let us know if it resolves your query and mark it as the best answer if it does so that other people can track the answer easily!

[klausbergh]

Hi Thank you. 


It dosen't work on my end i get this error.
I load data from another page collection. In both collections i have the same columns, but looks like it can't find the column2

[devneetmohanty07]

Hi Klaus,

Can you also show us the schema of the collections: OU Data and Coll1. If I am correct you are trying to filter from the collection OU Data and are storing the results in the Coll1 collection. 

Please provide us the screenshot of the schema of both the collections which are input and output to this action so that we can help you better on this.

[Kishore_KumarDe]

Your filter condition should just say "[Column2]='DK'". I think you are adding collection name in front of column name.