Update a column values from a CSV or text file before inserting/loading it on a table

Anonymous — Sat, 16 Nov 2024 07:26:11 GMT

Hello,

I would like to ask if it is possible to update a column values before inserting/loading it onto a table?

Something like in a typical MySQL database trigger, a trigeer before insert

for each row
begin
if (NEW.Col_name = 'values1'l) then
set NEW.Col_name = 'values1updated1'; end if;
if (NEW.Col_name = 'value21'l) then
set NEW.Col_name = 'values2updated'; end if;

if (NEW.Col_name = 'values3'l) then
set NEW.Col_name = 'values3updated'; end if;

end
//
delimiter ;

Or is there any different way to do this?; As I have 1 column with 3 different values depends on the action, that should be updated, before placing/inserting /loading the data on the target destination table to avoid "Data Column Values is too long" as I set the standard data types/sizes on the destination table, with a CHAR(1) and the data from the CSV file having CHAR(3).

Thank you very much for any idea or a solution.

Cheers

Re: Update a column values from a CSV or text file before inserting/loading it on a table

TRF — Sun, 21 Oct 2018 08:04:00 GMT

Pass your data into a tJavaRow or a tMap before to send them to your DB.
This is how it works with Talend DI.

Re: Update a column values from a CSV or text file before inserting/loading it on a table

Anonymous — Sun, 21 Oct 2018 17:29:06 GMT

Thank you Sir @TRF!

topic Re: Update a column values from a CSV or text file before inserting/loading it on a table in Talend Studio

Update a column values from a CSV or text file before inserting/loading it on a table

Re: Update a column values from a CSV or text file before inserting/loading it on a table

Re: Update a column values from a CSV or text file before inserting/loading it on a table