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