To generat a report in particular format

[deepikaBhatia]

Hi,I want to design a job which have following data Input :

Code: Select all

Col1 col2 col3......
a     b     r
b           e     
c     d  
            s

and what to have output report as show below:

Code: Select all

Col1 col2 col3          Message
a      b    r           No null column
b           e           col2 is null
c      d                col3 is null
            s           col1,col2 is null

and so on....

Out of the above output I am able to achieve when only 1 of the column is nUll or blank in a row but how to achieve when more then 1 column is null or blank at dat time i want to display the message "col1,clo2 and so on.. are null" Please help on this

Thanks

[chulett]

Fixed your examples for you. You need to use

Code: Select all

 tags to preserve whitespace.

[chulett]

Build the list of columns first, setting a stage variable to "col" when empty and ",col" when not. After all have been checked append " is null" to it if it is not empty when you add it to the output row or use "No null column" if it is.