# How to do concatenation with StreamSets?

Team, I am playing with Oracle and PostgreSQL using StreamSets. I am fetching the entire database using ORACLE CDC CLIENT and destination JDBC PRODUCER, but In Oracle I have table like ABC and in PostgreSQL like test_abc, how will i do with table concatenation ABC to test_abc ?? the following parameter is not working

test_${str:toLower(record:attribute('jdbc.tables'))}  edit retag close merge delete ## Comments What do you see with that? An incorrect table name? An error? ( 2019-05-14 10:11:51 -0500 )edit ## 1 Answer Sort by » oldest newest most voted I'm not sure why that isn't working, but you can use the str:concat EL function: ${str:concat('test_',str:toLower(record:attribute('jdbc.tables')))}

more