Hei!
This is my first time here 
I’ve already tried searching for the answer to my question, but unfortunately, I couldn’t find it. I’m hoping someone can help me out here.
My question is relatively straightforward, but as I’m new to HS, I require some guidance. I have ten existing lists, and what I want to do is create a new list that includes all the records from these ten lists. However, the new list should only contain records where the country property has specific values, such as US, Canada, and Mexico.
It’s important to note that I don’t want to merge all ten lists together. Instead, I aim to create a new list that only includes data from those lists where the country property matches my specified criteria.
Initially, I thought I would need to export all ten lists, merge them, filter the results, and then import them again. However, this approach requires a lot of manual work. So, I’m hopeful that there’s a more direct method to achieve this within HS.
Cheers!
