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}
g u m
l x o
c d z

Output :
Count_Rows Count_col1 Count_col2 Count_col3
           9                     8                  6                  5

No comments :

Post a Comment