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]

[jip31]

It's version 8.0.1

here is the table model

[Anonymous]

please double check the basic settings of tFileInputDelimited, especially the field separator, the component read the whole line as the first column.

[jip31]

Sorry i dont understand what you mean

could you write it here please?

[Anonymous]

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.

[jip31]

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

[jip31]

Is anybody can help please?

[Anonymous]

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

[jip31]

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

 

[Anonymous]

Open the file with notepad++, you will see the double quotes.

Modify your job to

tFileInputDelimited--main--tExtractDelimitedFields--main--tLogRow