Wednesday, 14 October 2015

DataStage Scenario #7 - Count data in each column


Count the total rows and cells which is having some data in it.





Input:

col1 col2 col3
 a {NULL} b
f k {NULL}
h {NULL} n
i d {NULL}
{NULL} s {NULL}
g u m
l x o
m {NULL} {NULL}
c d z



Output:

Count Rows Count_col1 Count_col2 Count_col3
9 8 6 5





Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://groups.google.com/forum/#!forum/datagenx