Why Import set is only updating not inserting new records

[Prathamesh Cha1]

error message

script to fetch RAM sys_id

(function transformRow(source, target, map, log, isUpdate) {

    var up = new GlideRecord('sn_risk_advanced_risk_assessment_methodology');

    up.addEncodedQuery("name=" + source.u_expected_ram + "^state=2");

    up.query();

    if (up.next()) {

        target.risk_assessment_methodology = up.sys_id;

    } else {

        ignore = true;

    }

excel sheet

if entity and current ram combination found simply update he record

if not insert new one

RAM is the field on target table which should get updates with expected RAM column from excel sheet

})(source, target, map, log, action === "update");

this is working fine for updates

[Hemanth M1]

Hi @Prathamesh Cha1 ,

Can you comment ignore =true; and try 

When your query wouldn't find existing record it goes to the else part and skipping everything.

  var up = new GlideRecord('sn_risk_advanced_risk_assessment_methodology');
    up.addEncodedQuery("name=" + source.u_expected_ram + "^state=2");
    up.query();
    if (up.next()) {
        target.risk_assessment_methodology = up.sys_id;
    } else {
        //ignore = true;
    }

[Prathamesh Cha1]

Hi @Hemanth M1 ,

Thanks for reply And I tried with solution you provided but still it is skipping the records, as records do exits with that encoded query.