I need to create a flow that update rows in my database based on csv file.
I have :
1- GetFile
status | client_id |
Active | 123 |
Inactive | 456 |
2- UpdateAttribute to update the Baobab_file (the schema is already in the AvroSchemaRegistry (collection)
3- SplitRecord to get each line
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