Page 1 of 1

Reporting on full table column analysis

Posted: Thu May 29, 2014 11:23 am
by deboots
I'm new to using Info Analyzer and haven't yet found the report I need.

IA gives you such great metadata about the columns in a table - but is there some way to see that in total? I'd love to see a report that show max, min, cardinality%, and implied format for each field. Right now it looks like I'll have to copy that manually into an Excel spreadsheet. That can't be right!?! What other options are there for me on 8.7?

Thanks in advance for your help!

Posted: Thu May 29, 2014 12:36 pm
by qt_ky
IA has many reports available to choose from. Have you looked under the Home menu / Reports / IA category / Column Summary category?

Thanks

Posted: Thu May 29, 2014 1:58 pm
by deboots
That's a good option. I do wish there was something in more of a table format instead of the book format. But thanks for narrowing it down for me - lots of reports to explore!

Posted: Thu May 29, 2014 6:38 pm
by stuartjvnorton
Take a look at IAAdmin -getColumnAnalysisResult. It just returns the data so you'll have to format it yourself, but it's an option to get the column summary results in a format that isn't just a butchered copy of the PDF / HTML version... <grumbles about data vs presentation, and from an IM product, no less>