Get row count in import set

[niharikayb]

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

[Sanjeev Kumar1]

Hi ,

Look it. it will help you

http://wiki.servicenow.com/index.php?title=GlideAggregate#gsc.tab=0

[johnram]

The ServiceNow Wiki content is no longer supported. Updated information about this topic is located here: GlideAggregate
 

Visit http://docs.servicenow.com for the latest product documentation

[Ankur Bawiskar]

Hi Niharika,

You want to print the import set record count after the transform runs or count related to the target table after the transform map ran

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

[Pranshu5]

Hi Niharika,

Could you please confirm of any final solution you have received?

I have the same requirement as well!

Thanks & regards,

Pranshu