Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I try to build the job described below
When I run the job, i have no error but also no results!
What is the problem please?
MM is used to describe months with two digits.
Example: 01-03-2023
MMM is used to describe the abbreviated month names.
Example: 01-Mar-2023
In your case, the value is 01-Mar-2023, so the corresponding date pattern is: dd-MMM-yyyy
Hi Team,
It says no rows are processed in your job. Can you ensure the schema and schema sync is done correctly? May be you can try without tmap initially and then add tmap for transformation.
Hi
It's what I done
The schema seems to be correct
It seems there is an issue to parse a field but i dont know how to correct this because Id field exists in my CSV source
Démarrage du Job TMAP2 à 05:59 08/03/2023.
[statistics] connecting to socket on port 3685
[statistics] connected
Couldn't parse value for column 'Id' in 'row1', value is '"1'. Details: java.lang.NumberFormatException: For input string: ""1"
[statistics] disconnected
My original source was this :
Id;Name;Department;StartDate;Salary
1;John Smith;Sales;01-Mar-2023;20000
If I replace Id=1 by Id=x and I replace Id=integer by Id= string, it works
why?
and I have another problem
If I replace ";' by "," , it doesn't works and I have pipe at the end of the output
Démarrage du Job TMAP2 à 10:01 08/03/2023.
[statistics] connecting to socket on port 3908
[statistics] connected
Id Name Department StartDate Salary
"x;John Smith;Sales;01-Mar-2023;20000"||||
"y;JP Ros;Commercial;04-Mar-2023;35000"||||
[statistics] disconnected
Hi
Double check your source data, the value is "1, there is a double quote before 1, so it is a string value, you can't use a 'Integer/int' type to read it.
In your source data, the field separator is ";"
Regards
Shong
Check this options to avoid the double quotes:
thanks, it was my issue....
Last question, I need to replace ";" by "|"
So I have done this in the tLogRow connector but the result is not goog because the pipe is put at the end.... (see screen 2)
what is wrong please?
There are 5 fields in your source data, you should define 5 columns on the schema of tFileInputDelimited to map each field, and set the field separator as ";" on tFileInputDelimited.
I think it's what I have done
It's strange! Which version of studio are you using? can you try to select 'table' model on tLogRow to check if the data display correctly?
Screen of your mapping please?