0

How to create array to be used for NP(Difference)?

Jet Reports Historic Posts

April 14, 2014 08:35

None

Follow

Hi,

i'm trying to use NP (Difference) function to find out the difference between two tables. Both my tables contain Fields of ("Batch","SerialNo","PinNo","Date"). I would like to create array with fields ("Batch","SerialNo","PinNo") only as "Date" field would not be used to find the difference. But i'm having problem to create the array using NL (Filter) function as i can only select a Field instead of multiple. Wonder if there's any way to do this?

My current Formula is as below:
=NL("Rows",NP("Difference",NL("Filter","TableA","SerialNo"),NL("Filter","TableB","SerialNo")))

This formula only generates the difference in "SerialNo" field, what i would like to do is to find the difference on other field too. Please advice.

Thanks.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts April 17, 2014 13:34

  Hi,
  the NP (Difference) only shows the differences in the table-entries, not in the fields…
  
  Array1: {100, 200, 300, 400, 500}
  Array2: {400, 500, 900, 1000, 2000}
  =>Difference {100, 200, 300}
  Union {100, 200, 300, 400, 500, 900, 1000, 2000}
  Intersect {400, 500}
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts May 09, 2014 05:21

  HI Jetsetter,
  
  Sorry for such a late reply. Now i know how to use the NP Difference.
  Thanks a lot for you help.
  
  Cheers.
  
  Best Regards,
  Kin9ho