Topic: How to update input records data type in the profiler?
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?
In the profiler, the number analysis option was disabled to for all column. What's the requirement to enable it?
What type is your input source?
To use the number analysis your columns need to be number types such as int, long, double, float etc...
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?
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?
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.
Thank you very much. I tried connecting to oracle database. worked fine.
Awesome tool!
I'm glad I came to know this tool!
Awesome tool!
I'm glad I came to know this tool!
Log in by clicking the login link at the top of the screen
Go back to forum.
