Transform script not working while loading the data , getting ignored

[Abhilasha G T]

Hi Team,

I have written on before transform script like below,

if(source.u.dns_name.contains('-sd-')){

    ignore = false;

    }

    else {

    ignore = true;

    }

Requirement is :

some data having DNS Name field contains,  -sd- , those data should insert into the target table, while loading

remaining data should get ignored , but its not happening all the data is getting ignoring now,

how to trouble shoot this,

Regards,

Abhilasha G T

[Sohail Khilji · Accepted solution]

Hi @Abhilasha G T ,

its simple to check , go for the below code:

if (source.u_dns_name && source.u_dns_name.indexOf('-sd-') != -1) {
    ignore = false;
} else {
    ignore = true;
}

I hope it helps you...  🙂

[Kieran Anson]

Hi Abhilasha,

It'll be due to an error in your syntax, you've used a period rather than underscore for the fieldname

source.u.dns_name.contains('-sd-')

source.u_dns_name.contains('-sd-')

However I'd consider future proofing your code by doing the following

var dnsName = source.getValue('u_dns_name');

if(dnsName.toLowerCase().indexOf('-sd-') == -1)
ignore = true;

[Sohail Khilji]

just a diffrence of 12 seconds @Kieran Anson  lol hehehe

[AnimeshP_96]

hey @Abhilasha G T 

have you tried the same script on field map script? if not try it or apply some logs and check if its entering into the loop

instead of contains you can try indexOf()/ substring() for ignoring those record with -sd-