How to insert or update a record in mySQL table if sourse db table name X and destination db table name Y using UpdateAttribute processor

AbhishekSingh — Mon, 11 Jul 2022 12:08:00 GMT

Hi,

How to insert or update a record in mySQL table if sourse db table name X and destination db table name Y using UpdateAttribute processor.

I am able to achieve this if source and destination has single table but I have multiple table where source db table's names A,B and destination table's names Y,Z . I tried below condition but getting a error.

schema.name : ${${databaseName}:equalsIgnoreCase(nrpsubscriptiondb2306):and(${tableName}:equalsIgnoreCase(status)):ifElse(subscription_status,${tableName})}

Error log: due to Unexpected token ':' at line 1, column 76. Query: ${${databaseName}:equalsIgnoreCase(nrpsubscriptiondb2306):and(${tableName}:equalsIgnoreCase(status)):ifElse(subscription_status,${tableName})}

Re: How to insert or update a record in mySQL table if sourse db table name X and destination db table name Y using UpdateAttribute processor

AbhishekSingh — Mon, 11 Jul 2022 14:40:12 GMT

I got solution for this.

TableName : ${databaseName:equalsIgnoreCase("nrpsubscriptiondb2306"):and(${tableName:equalsIgnoreCase("status")}):ifElse("subscription_status",${databaseName:equalsIgnoreCase("nrpuserorgdb2306"):and(${tableName:equalsIgnoreCase("status")}):ifElse("user_org_status",${tableName})})}

question Re: How to insert or update a record in mySQL table if sourse db table name X and destination db table name Y using UpdateAttribute processor in Support Questions

How to insert or update a record in mySQL table if sourse db table name X and destination db table name Y using UpdateAttribute processor

Re: How to insert or update a record in mySQL table if sourse db table name X and destination db table name Y using UpdateAttribute processor