finding column value frequency

Highlighted
One Star

finding column value frequency

I would like to compare two months of data in the same table and take a column and compare column value frequencies,
could you please help me out whether it is possible or not, and how to do it.

Any suggestions/help highly appreciated

cheli
Moderator

Re: finding column value frequency

Hi,

I would like to compare two months of data in the same table and take a column and compare column value frequencies,
could you please help me out whether it is possible or not, and how to do it.

A case with an example with input and expected output values will be preferred.
It seems that you use DQ frequency analysis and redundant compare?

Be regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: finding column value frequency

Thank you, here is the example

CL_NO CODE_VALUE COUNT MO_NO YR_NO

500 4 1000 06 2013
400 NULL 10000 06 2013



CL_NO CODE_VALUE COUNT MO_NO YR_NO

500 4 10000 07 2013
400 NULL 100 07 2013

Now I need something like this

CL_NO CODE_VALUE % OF DATA MO_NO YR_NO
500 4 1% 06 2013
500 4 10% 07 2013


I am not really particular about output format, any format is ok as long as I get the variance between two months that I compare.

cheli

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