No percent value in FD

xinhuang66 · Post by **xinhuang66** » Thu Aug 23, 2012 11:55 pm

I use Information Analyzer http api command line to export FD result.

However the csv file I get is like as following.

The value for percent is all empty..

Does anyone know why ? is it a bug ?

value,frequency,percent
2,1,
1,1,
3,1,

rjdickson · Post by **rjdickson** » Fri Aug 24, 2012 8:02 am

Hi,

This is expected. i believe the 'percent' header is incorrectly in the csv output. You will notice it is not there at all if you use -xml output option.

So, you can safely ignore the column.

xinhuang66 · Post by **xinhuang66** » Mon Aug 27, 2012 5:24 pm

This is a bit weird, I do need percent.

Is it possible to change the xsd file to get the percent ?

rjdickson · Post by **rjdickson** » Tue Aug 28, 2012 4:46 am

Hi,

I don't think it is the fault of the ISD. I think that the percent output is just not there. Open a PMR with your support provider to try to get it in the results.

Meanwhile, there are many ways you can calculate the percent yourself after retrieving the results. For example, using an Aggregation stage in DatatStage/QualityStage.

stuartjvnorton · Post by **stuartjvnorton** » Tue Aug 28, 2012 6:51 am

rjdickson wrote: Meanwhile, there are many ways you can calculate the percent yourself after retrieving the results. For example, using an Aggregation stage in DatatStage/QualityStage.

This would only work if you didn't apply any minimum frequency conditions.

If you did, you would also get the column analysis results for the total rows profiled count.