help on tMap

[jip31]

Hi

I try to build the job described below

URL

When I run the job, i have no error but also no results!

What is the problem please?

[Anonymous]

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.

[jip31]

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

[Anonymous]

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

[Informatique1]

Check this options to avoid the double quotes:

[jip31]

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?

[Anonymous]

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.

[jip31]

I think it's what I have done

[Anonymous]

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?

[Informatique1]

Screen of your mapping please?