Topic: How to update input records data type in the profiler?

Topic by indy 2009-10-30 12:26	How to update input records data type in the profiler? How to update input records data type in the profiler? In the profiler, the number analysis option was disabled to for all column. What's the requirement to enable it?
Reply by asbjorn 2009-10-30 12:46	What type is your input source?
Reply by kasper 2009-10-30 20:45	To use the number analysis your columns need to be number types such as int, long, double, float etc...
Reply by indy 2009-10-31 02:15	it's comma delimited file and it contains: product,price A,281.00 B,25.00 C,300.00 D,100.00 The profiler reads price as varchar data type, where/how to change it to number/float?
Reply by kasper 2009-10-31 09:07	Unfortunately, currently you can't. My best advise is to stage the data in a database where you can better control the datatypes before you profile it. Most databases contain a quick way to import a CSV file for just this purpose.
Reply by indy 2009-11-02 03:33	Thank you very much. I tried connecting to oracle database. worked fine. Awesome tool! I'm glad I came to know this tool!
	You need to be logged in to participate In order to post your own comments on this topic, you need to be logged in. Username: your comments Log in by clicking the login link at the top of the screen

How to update input records data type in the profiler?