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?

[jip31]

Your are right concerning the double quotes so I have deleted it

It's alittle better now, i have modify the job like asked

But when I run the job it's good until the name but after there is "x" in the field Department and after nothing

Here is the schema

[Informatique1]

Check your date format in your file you have "23-mar-2023" but you put "dd-MM-yyyy" in your tMap.

Here's the tMap you need:

 

Result:

[Anonymous]

If you remove the double quotes from source file, you don't need tExtractDelimitedFields component any more, just use tFileInputDelimited to read the file and print the data on the console using tLogRow

tFileInputDelimited--main--tLogRow

Change the date pattern to "dd-MMM-yyyy" of startdate column on the schema.

[jip31]

Hi

I dont understand why you tell the format is "dd-MMM-yyyy" because the date is : 01-mars-23

So at less it's "dd-MMM-yy" no? And why 3 "MMM"?

And even if I replace the StartDate format in my CSV by (01/03/2023 instead 01-mars-23), I have the same issue even if I use "dd-MM-yyyy" format

I tried many combinaisons but it doesnt works

[jip31]

Hi

Like I said to Chong I dont understand why you tell the format is "dd-MMM-yyyy" because the date is : 01-mars-23

So at less it's "dd-MMM-yy" no? And why 3 "MMM"?

And even if I replace the StartDate format in my CSV by (01/03/2023 instead 01-mars-23), I have the same issue even if I use "dd-MM-yyyy" format

[Anonymous · Accepted solution]

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

[jip31]

Many thanks for these informations, these time, it works!

[jip31]

Many thanks for these informations, these time, it works!

[Informatique1]

Ok please like good answers it helps.