cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Urgent: How to load complex data strctures from csv such as this one?

pborah88
Node Clone

I have data in a csv that looks like follows -

As you can see it is a complex data structure something along the lines of -

{
	{
	Object Name: P_ADS_BEX_COMMON.DM_OMNITURE_SITE
		{
		PRODUCT: Teradata
		INTERACTION_TYPE: Select
		INTERACTOR_USERNAME: annchaudhary
		INTERACTOR_DIVISION: EPS
		INTERACTOR_SUBDIVISION: EPSExpAffiliateNetwork
		INTERACTOR_COUNTRY: UnitedKingdom
		INTERACTOR_ACCOUNTTYPE: USER
		INTERACTOR_BUSINESSTITLE: SoftwareDevEngineerII
		INTERACTION_COUNT: 6
		key: P_ADS_BEX_COMMON
		TYPE: View
		SMA: ADS_BEX_COMMON
		DATABASE_LAYER: ADS
		SUBJECT_AREA: Common
		DESCRIPTION: CommonreferencedatawithinBrandExpedia.
		GROUP_CODE: EDE
		}
		{
		PRODUCT: Teradata
		INTERACTION_TYPE: Insert
		INTERACTOR_USERNAME: satripathy
		INTERACTOR_DIVISION: PlatformandMarketplaces
		INTERACTOR_SUBDIVISION: PMHubCapabilities
		INTERACTOR_COUNTRY: India
		INTERACTOR_ACCOUNTTYPE: USER
		INTERACTOR_BUSINESSTITLE: SoftwareDevEngineerII
		INTERACTION_COUNT: 1
		key: P_ADS_BEX_CLICKSTREAM
		TYPE: View
		SMA: ADS_BEX_CLICKSTREAM
		DATABASE_LAYER: ADS
		SUBJECT_AREA: Clickstream
		DESCRIPTION: ClickstreamdataforBrandExpedia.IncludesTravelocity,OrbitzandCheapTickets.
		GROUP_CODE: EDE
		}
	}
	{
	Object NAME: ads.gso_sforce_currn_code
		{
		PRODUCT: Hive
		INTERACTION_TYPE: SELECT
		INTERACTOR_USERNAME: gsoetl
		INTERACTOR_DIVISION: LodgingPartnerServices
		INTERACTOR_SUBDIVISION: LPS-GSO
		INTERACTOR_COUNTRY: 
		INTERACTOR_ACCOUNTTYPE: ETL
		INTERACTOR_BUSINESSTITLE: 
		INTERACTION_COUNT: 44
		key: N/A
		TYPE: Table
		SMA: 
		DATABASE_LAYER: 
		SUBJECT_AREA: 
		DESCRIPTION: 
		GROUP_CODE: 
		}
		{
		PRODUCT: Hive
		INTERACTION_TYPE: SELECT
		INTERACTOR_USERNAME: gsoetl
		INTERACTOR_DIVISION: LodgingPartnerServices
		INTERACTOR_SUBDIVISION: LPS-GSO
		INTERACTOR_COUNTRY: 
		INTERACTOR_ACCOUNTTYPE: ETL
		INTERACTOR_BUSINESSTITLE: 
		INTERACTION_COUNT: 50
		key: N/A
		TYPE: Table
		SMA: 
		DATABASE_LAYER: 
		SUBJECT_AREA: 
		DESCRIPTION: 
		GROUP_CODE: 
		}
	}
}

Where Object_NAME is a node and the rest of the columns are properties of that node. For the same node, each property has multiple values. I know I can set a list of of values to a certain property key. However in this case, going by the csv, I want to preserve the uniqueness of the various property combinations on a row by row basis. Redrawing the graph to convert some of the properties into nodes is NOT an option given my use-case.

A) How do I load something like this?
B) How do I query something like this?

1 REPLY 1

intouch_vivek
Graph Steward

Hi
Are you expecting to create dynamic labels using cypher and then merge the nodes with similar properties?

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

All the sessions of the conference are now available online