Hi, You can use stage variables for arrieving this logic svCntType1 => If LNK_Source.ContactType = 'E' Then LNK_Source.ContactDetails Else '' svCntType2 => If LNK_Source.ContactType = 'M' Then LNK_Source.ContactDetails Else '' Place the svCntType1 against the EMail field (target) and svCntType2 agai...
I have a source S and Hash file H as lookup. Source S is looked up against the Hash based on 5 fields. I need to get the matched records based on the 5 fields from the source. But the data for 2 fields may be null. Will I get wrong result because of null data?
Hi, I have say 1000 records in the source and when looked up against a hash it matches only 200. Now, I should load 1000 into target instead of 200 Here for one field I get the value from the lookup i.e. 200 records with values for the lookup field from the hash file and for the rest 800 records the...
Hi, You can avoid duplicate records by following the below steps Sort the records and in the transformer call a routine that contains basic code as below DupFlag="N"; if trim(prNo)=trim(Field1) then DupFlag="Y"; end prNo= Field1; Ans=DupFlag; Filter out DupFlag = "Y" in...
Hi, Try this... m1 ... m12 are the months. In the target add 12 columns additionally like below m1....m12 r1...r12 set r1 = 1 r2 = 2...and so on. Now use pivot stage to transform m1 ... m12 and r1...r12 in to rows like below monthval rowval m1 1 m2 2 m3 3 . . . . Hope this gives you an idea - :lol: