DSXchange

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!

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.

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.

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!

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

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.