Need help in loading data to neo4j "ABC" label using the jdbc load statement where input to the query will be from one of the output value of "XYZ" label already available in Neo4J

Neo4j Graph Platform Procedures & APOC
1

Hello Team ,

Need help in loading data to neo4j "ABC" label using the jdbc load statement where input to the SQL query will be from one of the output value of "XYZ" label already available in Neo4J.

For example-

ALREADY EXISTS LABEL:

MATCH (n:JCP_OLT_NC) WHERE n.EQUIP_NAME in [ 'INDLNOIDALPBNB1001ENBOLT001' , 'INMUNVMBNRLJNB0001ENBOLT001'] return n.EQUIP_NAME

SQL QUERY:

with "jdbc:oracle:thin:sqmread/Qwcbd4#g@10.147.161.47:1522/XCOMSTB2" as url
CALL apoc.load.jdbc(url,"select * from RJILCUSTOMISATIONS.RIL_UTM_PATH_V where PATH_TYPE ='OLT ACCESS PATH' and PATH_ZSIDE_EQUIPMENT IN ('INDLNOIDALPBNB1001ENBOLT001' , 'INMUNVMBNRLJNB0001ENBOLT001')
") YIELD row return row

SO i need to use n.EQUIP_NAME In my sql query ( where clause ) to fetch the data and once the data will be fetched , I will create new label which will have the records for those which comes from above mentioned returned statement.

Let me know how to perform this?

Thanks in Advance!

Regards
Akshat

2

Hello Team,

Please help .... I am still waiting for an input from the team.

Regards
Akshat