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

Ravi Gaurav
Giga Sage

Hi @vidishaagarwal5 

Create onBefore transform script and add this
Add your code 

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

vidishaagarwal5
Tera Expert

This is Awesome .. how fast I got the Answer is really Appreciated!!

Ankur Bawiskar
Tera Patron

@vidishaagarwal5 

yes this is possible.

you can use onBefore transform script and skip the 1st 50 rows

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    // Add your code here
    var currentRowNumber = source.sys_import_row;
    if (currentRowNumber < 50) {
        ignore = true;
        log.info('Skipping this row ' + currentRowNumber);
    }

})(source, map, log, target);

If my response helped please mark it correct and close the thread so that it benefits future readers.