0

Creating Filters from an Array

Malcolm Johnson

February 13, 2018 14:47

None

Follow

Hi All

 

I have situation that looks like this:

A table with a Line Number and on each line a NAV filter that looks like this:

Line No.           NAV Filter

100                  A..C

200                 E..H

300                 K..P

I have an Array this gives the Line No. as 100|200|300 

I would like to create a filter that shows:    A..C|E..H|K..P

Any idea on how I can do this?

 

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis February 13, 2018 16:01

  Something like this?

  

• 0
  
  Malcolm Johnson February 14, 2018 10:38

  Hi Harry

   

  Thanks for that - the NP Join function helps but has thrown-up another issue that is a little difficult to explain, but here we go

   

  I have found that the NP Join function fails where the first value is 10000

  In the first group the first line array value returns 10001 - and gave the expected results

  However in the second group the first value in the line array is 10000.  in this case jet is inserting a spurious pipe value as the start of the results.

  

  Apologies if this is poorly explained  the error is the first value on the last line

   

  Many thanks

   

  M  

   

   

   

• 0
  
  Harry Lewis February 14, 2018 16:17

  Hi.

  That would appear to indicate that there is a blank value at the beginning of the array.

  

  Are you able to duplicate this in a way (i.e., without a data source) where I could reproduce it?