Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using Neo4j. First, I import this CSV file into Neo4j: USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM file:/test.csv AS csv CREATE (:Transaction {ID: csv.id,
Using Neo4j.
First, I import this CSV file into Neo4j:
USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file:/test.csv" AS csv CREATE (:Transaction {ID: csv.id, Item: csv.item, Year: csv.year, Month: csv.month, Day: csv.day});
Next, I need to create a new table that loads the Year, Month, and Day from Transaction.
So I need a table like this...
TimeDimension: Year, Month, Day
In Neo4j, how can I use an existing table (Transaction) to pull Year, Month, and Day into another table TimeDimension?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started