All Forums Tools
zeesh49 3 posts Joined 03/12
10 Jul 2014
FASTLOAD ERROR

Dear All,
I am trying to fload a flat file, the file contains 44 columns (44 'Û' delimiters). 
Following is the sample header and data rows (header is removed from the actual file being loaded):

HEADER:

IDÛIC.STMCR.PERIOD.FIRST.DATEÛIC.STMCR.PERIOD.LAST.DAT EÛIC.STMCR.CR.INT.DATEÛIC.STMCR.CR.NO.OF.DAYSÛIC.STMCR .CR.VAL.BALANCEÛIC.STMCR.CR.INT.RATEÛIC.STMCR.CR.INT.A MTÛIC.STMCR.CR.INT.CATEGÛIC.STMCR.CR.INT.TR.ACÛIC.STMC R.CR.INT.TR.PLÛIC.STMCR.CR.INT.TAX.CODEÛIC.STMCR.CR.IN T.TAX.RATEÛIC.STMCR.CR.INT.TAX.AMTÛIC.STMCR.CR.INT.TAX CATEGÛIC.STMCR.CR.INT.TAXTRSDRÛIC.STMCR.CR.INT.TAXTRSC RÛIC.STMCR.LIQUIDITY.ACCOUNTÛIC.STMCR.COMPENS.ACCOUNTÛ IC.STMCR.INT.NO.BOOKINGÛIC.STMCR.TOTAL.INTERESTÛIC.STM CR.TAX.FOR.CUSTOMERÛIC.STMCR.TAX.FOR.BANKÛIC.STMCR.GRA ND.TOTALÛIC.STMCR.CORRECTION.NUMBERÛIC.STMCR.LIQUIDITY .CCYÛIC.STMCR.ICA.POST.INTERESTÛIC.STMCR.ICA.MAIN.ACCT ÛIC.STMCR.ICA.DIST.TYPEÛIC.STMCR.ICA.DIST.RATIOÛIC.STM CR.ICA.INT.CATEGÛIC.STMCR.ICA.TR.ACÛIC.STMCR.ICA.TR.PL ÛIC.STMCR.ICA.MAIN.INTÛIC.STMCR.ICA.SUB.INTÛIC.STMCR.G R.INT.TAX.LCYÛIC.STMCR.NET.INT.TAX.LCYÛIC.STMCR.GR.INT .TAX.FCYÛIC.STMCR.NET.INT.TAX.FCYÛIC.STMCR.CR.MIN.VALU EÛIC.STMCR.CR.MIN.WAIVEÛIC.STMCR.UNADJ.TOTAL.INTÛIC.ST MCR.INT.POST.DATEÛIC.STMCR.TAX.EXCH.RATEÛ

DATA ROW:

0002894473- 20131231Û20130701Û20131231Û20130701ý20131001ý20131201Û 92ý61ý31Û616.94ý13.94ý13.94Û6.00ý6.50ý7.00Û9.33ý0.15ý0 .08Û50000Û381Û380Û3Û10.00Û0.96Û17215Û875Û876ÛÛÛÛ9.56Û0 .96ÛÛ8.6ÛÛPKRÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ20140101ÛÛ

 

I am getting the following error:

Error on piom GET ROW: 61, Text: Warning, too few columns !ERROR! Delimited Data Parsing error: Too few columns in row 1

 

kindly help.

-Zeeshan

-Zeeshan
Tags:
dnoeth 4628 posts Joined 11/04
10 Jul 2014

Hi Zeeshan,
it's hard to tell without more info.
Did you use VARTEXT and the correct DELIMITER?
Did you DEFINE all fields as VARCHAR?

Dieter

zeesh49 3 posts Joined 03/12
10 Jul 2014

hi Dieter,
yes I used VARTEXT and the correct DELIMITER, also, I defined each field as VARCHAR.
Ive been stuck with this problem for 2 hrs, and I cant find any documentation of the error anywhere. Any help will be highly appreciated. 

-Zeeshan

dnoeth 4628 posts Joined 11/04
10 Jul 2014

Hi Zeeshan,
this error indicates there are less fields in your input record than DEFINEd.
Btw, 44 delimiters define 45 columns, but this should not the source of your problem.
 
 

Dieter

krishaneesh 140 posts Joined 04/13
10 Jul 2014
20131201Û 92ý61ý31Û6

from the value after the 4th delimiter is it entered as a new row in the data?

zeesh49 3 posts Joined 03/12
10 Jul 2014

@Dieter,
Yes there are actually 45 columns, not 44, so I added one more column to the fastload script, but still the same error. I even removed an extra column to make the total number of columns to be 43, still the same error...
@krishaneesh
No it is not a new row, the row is actually wrapped in this forum's post.

-Zeeshan

You must sign in to leave a comment.