User defined Buckets

Highlighted
One Star

User defined Buckets

I am doing a column-analysis a particular varchar2 column, this column has a variety of string values

Now i need to come up with an analysis for the length of the string in that column:

So my output should look like:

length <10 : 5%
length >10 <20 :60%
length >20 :35%


In short, can i define a bucket range ???

Your help will be appreciated greatly
Employee

Re: User defined Buckets

Hello,

I have created a UDI called "Length Range Frequency" that you can download from Exchange.
Simply unfold the "Libraries/Exchange/Indicator" folder in your studio.
Then import this indicator.

The current implementation is only for MySQL.
But you may edit it and add the SQL template specific to your database.
One Star

Re: User defined Buckets

Thanks bro ,

That worked like a charm.....


One more thing can we customize the graph generated??? for eg: the colour of the graph??
Employee

Re: User defined Buckets

no, you may not customize the graph by default.
What you can do is simply change some properties of each generated chart with a right-click on the chart.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read