I am tryng to load the data from CSV file to TD table using TPT..I am using version14.10..TPT havng delimiter as ',' and also in the csv file I have data in below format..How can I load this data.
SEQ_ID ,Prod_TYPE ,ACTIVE_ID ,Region_MAX_LAT ,Region_MAX_LONG ,AR_MIN_LAT ,AR_MIN_LONG ,AR_NUMERIC_ID ,CD_ACQUISITION_ID ,CD_SYSTEM_ID ,EFf_DATE ,EXP_DATE ,LOCAL_SYSTEM_ID ,PPDM_GUID ,PRED_NAME ,REMARK ,SOURCE_TD ,SOURCE_DOCUMENT ,ROW_CHANGED_BY ,ROW_CHANGED_DATE ,ROW_CREATED_BY ,ROW_CREATED_DATE ,ROW_QUALITY
Msrd,ABC_DEF,Y,,,,,4,,,,,,,'BKC Company, Ltd.',,EMW,,,,ETLR,,AWD
I tried with enclosing data with comma with double quotes...but its giving m below error..Please guide me on this..i am using Update operator as I need to use format expression for date column...So cant go for fastload..i,e. load operator in TPT..there is no EOF character..Also in the notepad for this csv, I have place cursor to next line..
Facing error due to data having comma and also dot ...and my csv have delimiter as comma
UPDATE_OPERATOR: entering DML Phase
UPDATE_OPERATOR: entering Acquisition Phase
FILE_READER: TPT19350 I/O error on file '/data/scripts/AR.csv'.
FILE_READER: TPT19003 Delimited Data Parsing error: Too many columns in row 1
FILE_READER: TPT19221 Total files processed: 0.
UPDATE_OPERATOR: disconnecting sessions
Kindly revert about how can I handle such data...
Thanks in advance..Awaiting for response..
This esolution has been done..My data in csv file had same symbol as i m using as delimiter..So I added
in the DEFINE OPERATOR FILE_READER
TYPE DATACONNECTOR PRODUCER
VARCHAR OpenQuoteMark = '"',
VARCHAR CloseQuoteMark = '"',
VARCHAR Format = 'Delimited',
VARCHAR OpenMode = 'Read',
It worked well and data got loaded....!!! :-)