Is there a way from Insight CVS import to not duplicate object but instead add parent link?

Question

Good Morning,

Need your guidance on this one :-)

I have a simple CSV that contain for each line: SPACEKEY, SPACENAME, USERNAME, GROUPNAME as listed below

SPACEKEY      SPACENAME                                    USERNAME      GROUPNAME
SJKB          SOC Business Enablers KnowledgeB     cking               SOC_WIKI_EDIT
BERM        Business Enablers & Resource Mgmt    cking               SOC_WIKI_EDIT
SJKB          SOC Business Enablers Knowledge B     dfahey            SOC_WIKI_EDIT
BERM         Business Enablers & Resource Mgmt    dfahey            SOC_WIKI_EDIT

I have 2 Object type:
1) Space: There is a Groups attribute  (type object pointing to Groups object type) 
2) Groups: There is a "Space name" attribute  (type object pointing to "Space name" object type).

Import result show 4 users, but in reality there are only 2 but each linked to 2 spaces.

is there a way to merge identical user and have a milti  reference to Spaces ?

Thank you !

sylvain_lanthier2_bell_ca · Accepted Answer

Question should have been written as below (sorry for the confusion)

I have a simple CSV that contain for each line: SPACEKEY, SPACENAME, USERNAME, GROUPNAME as listed below

SPACEKEY    SPACENAME                                         USERNAME GROUPNAME
SJKB             SOC Business Enablers Knowledge B   cking            SOC_WIKI_EDIT
BERM           Business Enablers & Resource Mgmt   cking            SOC_WIKI_EDIT
SJKB             SOC Business Enablers Knowledge B   dfahey          SOC_WIKI_EDIT
BERM           Business Enablers & Resource Mgmt   dfahey          SOC_WIKI_EDIT

I have 2 Object type:
1) Space: There is a Users attribute (type object pointing to Users object type)
2) Users: There is a "Space name" attribute (type object pointing to "Space name" object type).

Import result show 4 users, but in reality there are only 2 but each linked to 2 spaces.

is there a way to merge identical user and have a milti-reference to Spaces ?