Member since
08-28-2024
3
Posts
3
Kudos Received
0
Solutions
09-06-2024
01:42 PM
Hi all, I'm a newbie. I want to read a local .csv file that contains only an ID column, then use that list of ID in a dynamic query to get data from an oracle table. My flow is as below: I configure processors as following: +ReplaceText(1): is to replace "\n" with "," + ReplaceText(2): Remove the last empty row + ExtractText: assign ID list to attribute named list_id +UpdateAttribute: to specify name and value of property. The list contains 10 ID + ExecuteSQL: There is no task In for UpdateAttribute, the flow stop at ExtractText, the detail tab in view data governance is below, it said File.Size is 0 bytes. However it doesn't return any error so I don't know where to fix. Could you please help. Thank you
... View more
Labels:
- Labels:
-
Apache NiFi
08-30-2024
07:54 AM
1 Kudo
Thank you so much, it works perfectly
... View more
08-28-2024
04:56 PM
2 Kudos
Hello, I want to copy record from one table to another table that has the same structure in Oracle 12c+. One not-null column in source has white space. When trying to insert record to the target table, I got error "cannot insert NULL", so I added UpdateRecord processor to replace Null with white space, but still have the same error. It works if I replace Null with any other character like "_". Is there any way to keep white space when inserting to the target table? Below is my Flowfile and the UpdateRecord properties. Thank you
... View more
Labels:
- Labels:
-
Apache NiFi