Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
03-02-2020 12:05 PM
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?
03-02-2020 09:44 PM
Hi
Are you expecting to create dynamic labels using cypher and then merge the nodes with similar properties?
All the sessions of the conference are now available online