Can we export the column analysis result

xicheng_my_love · Post by **xicheng_my_love** » Thu Mar 29, 2012 2:35 am

Currently we click columns one by one and select COPY to copy the column analysis result to Excel. Can we export it to file, say a comma delimited text file? Or can we use, like Perl, to pull it from IADB and write to an Excel file?

Thanks!

ray.wurlod · Post by **ray.wurlod** » Thu Mar 29, 2012 3:05 am

IA has many out-of-the-box reports. One of the Column Analysis reports will probably achieve what you want. And reports can be output in a number of formats.

qt_ky · Post by **qt_ky** » Thu Mar 29, 2012 4:35 pm

If you're on the Column Analysis screen, look in the top right corner for a down-arrow menu to click on. From there choose Create Report. You can create reports from other menus also. Run through the wizard. For Excel, choose Output Format of XLS.

xicheng_my_love · Post by **xicheng_my_love** » Fri Mar 30, 2012 2:46 am

Still can not figure out what to click to generate the report.

We need to COPY the Frequency Distribution to Excel. IA version is 8.0.1.0.

<a href="http://www.flickr.com/photos/10494487@N00/6882808426/" title="Column_Analysis"><img src="http://farm8.staticflickr.com/7106/6882 ... d589b6.jpg" width="500" height="248" alt="Column_Analysis"></a>

Thanks!

qt_ky · Post by **qt_ky** » Fri Mar 30, 2012 5:31 am

The little button I mentioned is not there in your version 8.1 screen shot. Someone else will know...

abhi.inventor · Post by **abhi.inventor** » Mon May 28, 2012 11:58 pm

When u generate reports, in the last screen you have an option for saving your file. There you can select any specified format you want.

The report will be stored in the Reports folder in the server I believe.