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

vidishaagarwal5
Tera Expert

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

2 ACCEPTED SOLUTIONS

Ravi Gaurav
Giga Sage

Hi @vidishaagarwal5 

Create onBefore transform script and add this
Add your code 

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

View solution in original post

5 REPLIES 5

miftikhar20
Kilo Patron

@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;
    }