How we can add 51-100 record out of 100 record available in Excel file.

[vidishaagarwal5]

Can we use Transform Script. coz I need to load data via excel sheet?

[Ravi Gaurav · Accepted solution]

Hi @vidishaagarwal5 

Create onBefore transform script and add this
Add your code 

if(source.sys_import_row >= 100 ){ error = true; }

[M Iftikhar]

@vidishaagarwal5 ,

• Go to System Import Sets > Transform Maps

• Open your Transform Map

• Add script to the Transform Script (onBefore) 

 if (source.sys_import_row  < 50) {
        ignore = true;
        return;
    }