how do you connect comptr table with category table?

PARTNER Erwin Herwijnen

data source Super Office mirrorring tool is in use. Through Tableau connect two tables 'comptr' and 'category'. 

This way I can distinguish the various steps per comptr. In use are the name (comptr) and name (category). However, the results are not connecting. Category names and competitor names are  null when matched.  

It would be great to include this per month for an overview in Tableau through SuperOffice tables. 

with kind regards,

Erwin

PARTNER /da/My-Page/11000/

RE: how do you connect comptr table with category table?

Hello,

There is no connection between the comptr and category list tables.

Category is used on contact or person level, to specific the category.

Comptr is the Competitor used on Sale level.

They are 2 seperates list without any connection between them.

 

Af: David Hollegien 24. dec 2018
PARTNER /da/My-Page/13286/

RE: how do you connect comptr table with category table?

and how about combining it through another fx sale table? 

Af: Erwin Herwijnen 24. dec 2018
STAFF /da/My-Page/4982/

RE: how do you connect comptr table with category table?

Check sale table

Sale.contact_id.category_idx

Sale.comptr_id

 

See here: https://community.superoffice.com/documentation/SDK/SO.Database/html/Tables-sale.htm

Af: Margrethe Romnes 25. dec 2018
/da/My-Page/6205/

RE: how do you connect comptr table with category table?

It's important to clarify here that a competitor is not an actual company entity in SuperOffice. The competitor field on sale is just a simple list with no relation to companies stored in SuperOffice, therefore there's no relation between the comptr table and the category table, see this diagram.

Af: Matthijs Wagemakers 27. dec 2018