Hi I am trying to do something and I am struck with the solution. Please it would be great if someone can help. I have data coming from 3 different sources.
Example:
exist_in_flag: mapping Load ID, 1 as exist_in_flag aaaa.qvd;
Table1: Load ID, InvoiceNo,addr, city , country,amt, ApplyMap('exist_in_flag',ID,0) as exist_in_flag from abc.qvd;
left join(Table2) load ID, addr, city, country, amt resident Table1 where exists_in_flag = 1;
concatenate load ID, addr, city , country resident Table1
where exists_in_flag=0;
Table3:
Noconcatenate load * resident Table2;
left join(Table3) load sid as ID, storename, storeaddr, storecity, storecountry, startdate from xyz.qvd;
The ID's are same in all the tables. I want to create a table which has fields like(ID, StoreNo, addr,city,country,amt,actual_date,fees) So the probblem is, I want to have the Storeaddr,storecity,storecountry to be taken first, if the values are NULL or blank then pick the addr,city,country from table1. I am trying to create this logic. But I don't know how to proceed.
Basically I want storeaddr,storecity,storecountry to be taken from Table 3 first, if it's not available then select addr,city,country from Table 1 and if the values are NULL in Table 1 then pick the previous value.
