0

Combine two databases in one row

Jet Reports Historic Posts

July 01, 2014 06:35

None

Follow

Hi everyone,

I would like to combine two databases in one row, because i would like to get information out of the filterdincident data and the filteredhig_werkbon). These are the formulas:

=NL("Rijen";"FilteredIncident";{

and

=NL("Rijen";"Filteredhig_werkbon";{

The unique key of the two databases is the cell hig_navid.

Does anyone here know how to do this? Thank you in advance, Annelies

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts July 01, 2014 07:59

  Correct me if I'm wrong, but do you mean you have an ID (hig_navid) and based on that ID you want the information of both tables in rows.
  
  If so, you can use two lines with the NL() functions and conditonally hide the one that has no data.
  Problem there is that you get the ID's of table one and below that the ID's of table two.
  
  If you want the lines sorted by ID, it is a little more complicated.
  
  Use NL(Filter) to retreive the ID's from either table (say cell D4 and D5)
  To display all ID's found you can use NL(Rows;NP(Join,D4,D5)): instead of a table you can use a list of anything
  Per line you can get the information from either table by referring to the ID
  
  Hope this helps
  
  rmw

• 0
  
  Jet Reports Historic Posts July 01, 2014 12:01

  Hi Annelies,
  
  Just to be sure if I understand you correctly.
  - you have one database with to tables:
  + FilteredIncident (registered incidents)
  + Filteredhig_werkbon (registered activities related to incidents, table-relation is on the hig_navid field)
  Is this correct?
  
  You could create a NL("Rijen";"FilteredIncident";;filters) in cell D4
  Then for example in column E a NF(D4;"hig_navid")
  Then in a next column NL("Rijen";"Filteredhig_Werkbon";;"hig_navid";"E4")
  In next columns you can retrieve field info from the retreived record by the NL("Rijen").
  
  Best regards,
  Gerard