Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Get row count in import set

niharikayb
Kilo Contributor

Hi all,

i have a data source file containing columns "PO number" and "assets" .After running   the transform,   i need to get the count of assets under each PO . How can i achieve this ? please suggest .

NOTE :

I am getting the total row count when am using below script :

ONCOMPLETE Transform Script:

var ast = new GlideRecord('u_dell_data');

ast.addQuery('sys_import_set',source.sys_import_set);

ast.query();

var count = ast.getRowCount();

gs.log("count of all assets":+count);

                             

Thanks in Advance,

Niharika

6 REPLIES 6

Hi Pranshu,

Were you able to get a solution for this?

I am stuck at the same place.

 

Thanks!

Hi Lavanya,

Did you raise a question regarding this? This question is quite older and hence not feasible to follow up on this

if yes then please share the link here; it can be checked

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader