0

Sort an NP Union

Yvonne Jury

August 30, 2017 23:50

Answered

Follow

Hello!

I have an NP Union where I want to sort the entire data set by date.  The data returned sorts the first NL Filter by date, and then sorts the second NL Filter by date.  How can I sort all the records by date?

 =NL("Rows",NP("Union",NL("Filter","Posted Work Order Line",,"+Work Order Date",$C$3,"type","From","document no.",NL("Filter","Posted Work Order Line","Document no.","Type","To","New Batch Owner",$C$2))),NL("Filter","Posted Work Order Line",,"+Work Order Date",$C$3,"type","To","new batch owner",$C$2))

Results:

 

• Facebook
• Twitter
• LinkedIn

2 comments

• 3
  
  Harry Lewis August 31, 2017 16:26

  Since I can't sort the NL(Filter) or the NP(Union) by an external field, the only way I know of to accomplish this would be for my NL(Filter) functions to create a list of entry numbers that I could then include in my NL(Rows) function to return records from my table - which I can sort

  Something like this:

  

• 0
  
  Yvonne Jury August 31, 2017 23:08

  Brilliant!! Thank you so much!!