September 22, 2008 at 11:48 pm
Prime Key ,Quote # ,Conv Indicator,Req Dt ,QMS Bar Code,MktKey
2.01E+16,3328920,0,20080620, ,222X58
2.01E+16,3328920,0,20071220, ,222X58
2.01E+16,3328920,0,20070619, ,222X58
2.01E+16,3328930,0,20071029,1.71E+11,T24009
2.01E+16,3328930,0,20070426,1.71E+11,T24009
2.01E+16,3328940,0,20070827, ,222X4A
2.01E+16,3328940,0,20070223, ,222X4A
2.01E+16,3328950,0,20071212, ,222X4A
HI,
I am loading flatfile(.csv) tha above one, i want to load Prime key and QMS Bar Colums into numeric.In flat file sourece, Advanced Tab i changed Prime key data type to Numeric, it is passing data to next transformation as Numaric. ( Remaining all column data type are in String(dt_str).
In QMS Bar column Blanks ( NULL) are there, i want to replace those null values with 0(Zero) and remaining (means which is having value) sholud conver to Numeric.
In Source file advanced tab if i take numeric data type it is throughing error in flat file only.
how can i achive this.
September 23, 2008 at 7:42 am
Try out the derived column transform as step 2 in your process.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply