Hi all
I am using 7.1 datastage v. windows xp.
I have 4 fields, circuit, phn, bill_info, bill
I have query,
we need to load the data into bill_info where ,
if circuit is null take the data from phn. and bill = 'phn'
if phn is null get the data from circuit.and bill='crc'
I given like : bill_info= if isnull(circuit) then phn else circuit.
Please help me on this.
Thanks in advance...
isnull() function
Moderators: chulett, rschirm, roy
isnull() function
Last edited by deva on Wed Jun 06, 2007 12:14 pm, edited 1 time in total.
no actually if we have circut we populate curcuit value into bill_info and we have another field say bill , we hotcode bill = crc,DSguru2B wrote:Your code looks fine. Is there something thats not working?
Have you considered the scenario in which both circuit and phn are null? Then what?
if we have phn then we populate phn value into bill_info and we hotcore bill = phn
You are saying the same thing over and over.
Tell me this, how will you handle the following:
What if both are not null?
What if both are null?
and between the two, which one take precedence (i.e, which one to check first)?
Tell me this, how will you handle the following:
What if both are not null?
What if both are null?
and between the two, which one take precedence (i.e, which one to check first)?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.