Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Mapping postegresql and csv file

Hey all , 

the purpose of my job is the mapping beetween a csv file and a database table  (Postegresql) so i must insert and update the table with cvs file's informations .It doesn't work. Any help ?

0683p000009M4gJ.png0683p000009M4gO.png

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

It was just a problem about parsing data (String ->int) in the tMap .

View solution in original post

2 Replies
vapukov
Master II
Master II

Hi,

 

you need to compare:

  • your real separator in the file (look like it is TAB (\t) )
  • used separator in the tFileInput
  • schema

 

Anonymous
Not applicable
Author

It was just a problem about parsing data (String ->int) in the tMap .