Suggestion for Row count option in HCI DS

[former_member423067]

Hello All,

I'm generating an output file from IBP and placing it in SFTP folder. The Trailer line in the file has the total record count.

I use gen_row_num() Function to calculate the Final Row count in the last Transform while generating the output file.

The Problem is, the Row count is getting populated wrong randomly.

on further analysis, I noticed, when the rows are sorted wrongly. The Row count is picked as the last row sorted.

for example, if there total 100 records. count is passed as 9,10 etc. 99 % this is populated correctly.

Is this a bug ? any suggestions to get the count correctly, without using another Aggregate Transform in the flow.

with regards, Nazeer

[former_member423067]

Hello Jeff,

Any suggestion to populate Total Record count in the file output.

use of gen_row_num() in the Trailer column in the Target Transform not working always.

I tried changing Degree of Parallelism to 1. still now change. The output is very random and not reliable.

with regards,

Nazeer