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.
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;
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
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]?
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
Yes, the order does matter.
Thanks for your help with this.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.