Sorter node using multiple flow variables

[fostc80857]

Hi

Is it possible to sort a table using two flow variables. My two flow variables are “vendor name” and “invoice amount”.

Currently, when using the sorter node, I only seem able to use one flow variable to sort, but I would like to sort first by vendor name then by invoice amount.

Thanks
Chris

[fostc80857]

To add to the above, this is my current sorter node set up:

I would like to replicate the below but using the two flow variables mentioned in the post above;

Thanks
Chris

[Daniel_Weikert]

Hi,
inclist has to brackets next to the symbol. That means you need to give it a collection of the columns you want to include in your filter. Then it should be possible
br

[fostc80857]

Thanks @Daniel_Weikert

Does the order of the collection matter? If I want to first sort by VENDOR_NAME and then by INV_AMOUNT does the collection have to be [VENDOR_NAME,INV_AMOUNT]?

Thanks
Chris

[Daniel_Weikert]

I think so but best try yourself as I have no example to test right now. Feel free to post your findings for the community here
br

[fostc80857]

Hi @Daniel_Weikert

Yes, the order does matter.

Thanks for your help with this.

Regards
Chris