We have moved to www.dataGenX.net, Keep Learning with us.

Monday, March 10, 2014

DataStage Scenario - Problem17




Goal : Count the data in each column


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


No comments :

Post a Comment