DSXchange

@ chulett yes, I know my constraints are wrong and the looKup has been successful so far but the problem comes when i added transformer stage to it and my o/p is comin to 1 target like ao records to 1 target and 0 records in trget 2 if possible can u plz post the correct syntax for constraints for t...

i have tried writing condition in transformer stage for constraints like
DSLink8.State_desc = " " for one link and
DSLink8.State_desc <> " " for second link but o/p is moved in to 1 target

can you be still more explain your requirement. how you are filtering the rows between two tables. if state name is present it should go to T1 and if it is null or empty it should go to T2. is that correct? @Romy yes, u exactly got my point There r 2 tables like CID,CNAME,STATE,STATUS Table 2 STATE...

I/P after using look-up is like this CID,CNAME,STATE,STATUS,State_desc 11,sun,AP,1001,ANDHRA PRADESH 22,moon,TN,1111,TAMIL NADU 33,star,KK,1000,KANYA KUMARI 44,pluto,JK,1011, 55,sunn,ap,1000, 66,rad,AP,1111,ANDHRA PRADESH 73,star,kk,1000, 84,pluto,JK,1011, 95,sunn,ap,1000, 46,rad,AP,1111,ANDHRA PRAD...

Table -1 CID,CNAME,STATE,STATUS 11,sun,AP,1001 22,moon,TN,1111 33.star,kk,1000 44,pluto,JK,1011 55,sunn,ap,1000 66,rad,AP,1111 73.star,kk,1000 84,pluto,JK,1011 95,sunn,ap,1000 46,rad,AP,1111 Table-2 state,State_desc AP,ANDHRA PRADESH TN,TAMIL NADU KK,KANYA KUMARI DL,DELHI Required output CID,CNAME,S...

change the forward slash to backward slash and give a try