Expression for Filter Largest to Smallest column as collection ?

[TDarrell9]

Hi,

I am trying to figure out how to filter a collection, I need the expression to filter a column within the spreadsheet by largest to smallest, can someone provide me the expression please as i am currently trying to spy excel itself to filter and having issues.

Thanks

Tom

 

[VJR]

Hi TDarrell9,

Could you clarify my doubts here-

"how to filter a collection"
This is referred to a collection

"expression to filter a column within the spreadsheet"
This is referring to the spreadsheet

"by largest to smallest"
This is about sorting and not filtering

Are you looking to sort a collection from largest to smallest?

 

[TDarrell9]

Hi,

Yes you are correct, I have been looking at the wrong business object, I have not noticed sort collection with the collection manipulation object. I will try using this and let you know the outcome.

Thanks

 

[VJR]

Hi,

Yes you are correct, I have been looking at the wrong business object, I have not noticed sort collection with the collection manipulation object. I will try using this and let you know the outcome.

Thanks

Yep, that is the action that should suffice your need.

 

[TDarrell9]

Yep, that is the action that should suffice your need.

Hi,

Seem to be having a issue with sort field, do you know what needs to be in the field, I have tried Column5, 5, the name of the column, but it says cannot find column... any ideas

Thanks

 

[VJR]

Hi,

Seem to be having a issue with sort field, do you know what needs to be in the field, I have tried Column5, 5, the name of the column, but it says cannot find column... any ideas

Thanks

Use the column name within double quotes - "ColumnName"

 

[TDarrell9]

Use the column name within double quotes - "ColumnName"

Hi,

Yes i have tried that doesn't seem to work, please see snip attached ?

Thanks

 

[VJR]

Hi,

Yes i have tried that doesn't seem to work, please see snip attached ?

Thanks

Remove the double quotes from the "True" and post back your findings. It is a Flag type so should be without the quotes.

 

[TDarrell9]

Hi,

Still no luck with it, just does not recognise the column.

 

[VJR]

Hi,

Still no luck with it, just does not recognise the column.

Is there a space after the word AMOUNT in the original collection heading in amount.PNG?

 

[TDarrell9]

Hi,

I managed to spy the elements I wanted as this did not work.

Thanks for the help