0

consildation of data for multiple entities

Jet Reports Historic Posts

July 09, 2015 16:11

None

Follow

Dear Community,

I am new bee to jet world. right now i am working with jet essentials in excel
i would like to know how can we consolidate data for multiple companies through table builder?/ any other way to get it

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts July 09, 2015 16:29

  Unfortunately, the table builder and the NL(Table) function can only pull from one company at a time.
  
  If you need to pull data from multiple companies, you will need to build the report outside of using Tables.

• 0
  
  Jet Reports Historic Posts July 15, 2015 23:04

  Hi nagaraju123,
  
  As JET-btr said, NL(table) can only have 1 base table so consolidating across companies can be difficult. BUT, if you have Jet Enterprise, you might be able to use the data warehouse (DWH) since it's purpose is to combine information from multiple tables. If you created a consolidated table in the DWH then you could use an NL(Table) to pull all the information you need.
  
  Just a thought.