Print Number Of records
Hi,
I need to print Total No Of records from Temp Table.
Could you please let me know how to write Syntax for this.
Regards
Former Member replied
Hi,
If you need to print the count in table
go for function total_rows(<datastore.owner.table_name>)
or to print the count in the trace log:
Step 1: create one global variable with data type int.
Step2 : $gv_count= sql('datastore name','select count(*) from table)
Step 2: after dataflow , in the script you can write the below code
Print('table name count is : ' || $gv_count);