Select top 3 records of a column using list functions

Hello,

I do not think so you can do it with "list of functions". But after your query activity add split.

1) in Record count limitation choose "Limit the selected records" option click edit

2) Keed the first ones after sorting

3) choose column and order

4) Choose size of records to keep

Hope this helps,

Marcel

Hi Marcel, thanks for this that did work!

I will admit I like to figure stuff out on my own through trial and error, however, I am struggling with this one. I think it's best if I provide a little more context about what I'm actually trying to do.

This is all about personalisation blocks in the template and where a value equals something they get a particular block in priority order, top down. Those values are coming through in a file, where a contact has duplicate rows and on each of those rows is a score. As discussed previously I want to pick up the top three scores, however, that leaves me with three rows per contact. I need to then transpose those values from a column to a row so that I can pass through one row per contact. This is why I was initially looking at using a function.

Any further thoughts?

Regards

Ross

Hi Marcel, thank you for this.

Yes, this is what I needed and with a bit of trial and error, I got there!

Thank you, greatly appreciated.

Regards

Ross

Mark as answered if so it would be appreciated

thank you..