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?
It's version 8.0.1
here is the table model
please double check the basic settings of tFileInputDelimited, especially the field separator, the component read the whole line as the first column.
Sorry i dont understand what you mean
could you write it here please?
I suspect you don't set the right field separator, tFileInputDelimited read the whole line of data as one column, so please double check the field separator.
The separator in my csv file is a semicolon so it's normal that I use also a semicolon separator as the field separator in tFileInputDelilited no?
Id;Name;Department;StartDate;Salary
x;John Smith;Sales;01-Mar-2023;20000
Is anybody can help please?
Hi
I noticed that there is a double quotes around the data,
"Id;Name;Department;StartDate;Salary"
"x;John Smith;Sales;01-Mar-2023;20000"
When the CSV option is checked, the component read the whole line as one value, so just define one column on the schema, and then use a tExtractDelimitedFields to extract each data from the input line, define the all columns on tExtractDelimitedFields.
tFileInputDelimited--main--tExtractDelimitedFields--main--tLogRow
Please try and let me know if it works.
Regardfs
Shong
I dont understand anything
In the csv file I sent you, there is no double quotes!
And if i modify the schema like you asked me, I have an error
Open the file with notepad++, you will see the double quotes.
Modify your job to
tFileInputDelimited--main--tExtractDelimitedFields--main--tLogRow