Data Profiling Results to Excel

Hi ,

Is there anyway we can download the data profiling result to excel spreadsheet? I know that we can save as in csv format for the intial profiling results such as min, max, median, nulls, patterns etc what i need is to go to next level and save the results for a particluar patterns or nulls.

Thanks
Joe


bobxi :singapore: (BOB member since 2006-07-21)

but you can open CSV in excell easily and then it can be saved as .xls file


GBS74 (BOB member since 2007-01-23)

You can also read the data directly from the repository tables and save that out to an excel worksheet…


fblau (BOB member since 2005-02-07)

Hi All,

We can do right - Click at the header of the View Data Window and SaVE IT as Profile.xls. Even we can save our data also in excel format.

However, i have a question that, how can we see profiled data if we using “Submit Column Profile Request”

I mean its very easy to get the profile data if we using Profile tab of the View Data Window…

Can we get the grahical view of profiled information?


sjain :india: (BOB member since 2009-04-17)

Hi All,

We can do right - Click at the header of the View Data Window and SaVE IT as Profile.xls. Even we can save our data also in excel format.

However, i have a question that, how can we see profiled data if we using “Submit Column Profile Request”

I mean its very easy to get the profile data if we using Profile tab of the View Data Window…

Can we get the grahical view of profiled information?


sjain :india: (BOB member since 2009-04-17)