@Shu This is the output of my EVALUATEJSONPATH Processor - Guess this is fine. This is the output of my REPLACETEXT processor Don't really much about this. This is the output of my PUTSQL processor If you see the values section is blank with just two commas. Can you please tell me what is going wrong. My insert statement in REPLACETEXT processor insert into [test_shailesh].[dbo].[nifiTest](policyID,statecode,county) values (${policyID},${statecode},${county}) my overall flow - ... View more

@Shu Can you please help me fix this error. It says Incorrect syntax near','. Not able to figure out where I am making this error. This is my CSV file. My insert statement is insert into [test_shailesh].[dbo].[nifiTest](policyID,statecode,county) values (${policyID},${statecode},${county}) ... View more

@Shu I've been hard-coding the replacement value property in REPLACE TEXT processor ( eg - "insert into table_name values (..)" ). Is there a way to do it dynamically.? Can I use reg-ex.? I tried a couple if things. It did not work. Can you please tell me what Search Value is.? ... View more

Hi.. i was following article to install sandbox on docker. I was successfully able to complete step 3. when I execute the command docker images I am able to see - Sandbox-hdp. I am stuck in step 4. I ran the command that you have in step 4. I get this error. am I doing it correctly? Should I change the hostname.? I am a beginner. Please help. ... View more

@Yash Hi..I changed the relationship in all my processors. I get this error in all of them. Please take a look. I am getting the relationship error in all my processors. This is what I did in the bridge that connects "InferAvroSchema" and "convert CSV to AVRO".(screenshot - 2) This is my "inferavro" configuration . When I select success in "Automatically terminate relationships" it gets selected and after I connect it to the next processor it gets un-selected automatically. Please take a look. ... View more

@Yash Hi.. Your understanding is right..I am trying to insert it into the table only. I just wanted to see what the output is at the end of the flow..That's why I added PUTFILE. I'll change it. Again thank you so much for replying. I'll make the changes and try again. ... View more

@Yash Hi man. I was following your answer step by step. I am getting error. Can you please help me fix it. I am getting error "Convert CSV to AVRO" and "Convert "AVRO to JSON "processors.(Ignore the 3 processors in the 1st row) Screenshot - 1 shows the errors. At Convert CSV to AVRO it says cannot find Schema. My Configuration of "CSV to AVRO" processor. At "AVRO to JSON "processor. "AVRO to JSON " configuration I was trying to get a text file which has CSV's from filezilla. That part worked. and then the second step infer Avro schema also worked. Is it because my CSV's are in text file, these errors occur.? The only difference between your input and mine is. You hard coded the headers($is,$ name..) and I set take header from the first line of the file. Is it because of that.? Please have a look man. Thanks ... View more

Thanks you so much man @Yash. I'll try this out.:) ... View more

Hi @Yash. Thank you so much for taking your time to reply to my Question. I am sorry I do not understand your answer. I do not know what nodes are. What I was trying to do is download a CSV file from filezilla and insert it into a table in sql server. I used FetchFTP to get a CSV file from Filezilla. Before inserting I though I would try writing the file into my local machine. That's where i got struck. Can you teach me how to insert it into a table in sql server. If you know any good tutorials. Please suggest me. Thanks ... View more