TPT Data load from csv file

Tools & Utilities
Enthusiast

TPT Data load from csv file

Hi ,

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..

1 REPLY
Enthusiast

Re: TPT Data load from csv file

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

 SCHEMA TGT_TABLE_SCHEMA

       ATTRIBUTES

        (

   VARCHAR OpenQuoteMark = '"',

   VARCHAR CloseQuoteMark = '"',

VARCHAR Format = 'Delimited',

   VARCHAR OpenMode = 'Read',

It worked well and data got loaded....!!!  :-)