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?
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
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:
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.
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
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
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
Many thanks for these informations, these time, it works!
Many thanks for these informations, these time, it works!
Ok please like good answers it helps.