Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Useing a CSV file content in SQL condition

avatar
Contributor

I need to create a flow that update rows in my database based on csv file.
I have :


1- GetFile

statusclient_id
Active123
Inactive456

 

2- UpdateAttribute to update the Baobab_file (the schema is already in the AvroSchemaRegistry (collection)

 

3- SplitRecord to get each line 

statusclient_id
Active123

 

4- ExecuteSQL : update table_client set current_status = status where id = client_id

 

How can I do this I tried ${status} and \status but no luck

 

Thank you

1 ACCEPTED SOLUTION

avatar
Super Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
1 REPLY 1

avatar
Super Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login