How to profile N number of rows in a table


(chetan palwe) #1

Hi,
I would like to profile n number of rows (ex: 100 rows) out of million record in a table, so Is it possible in DQ analyzer?


(Victoria Tuktarova) #2

Hello Chetan,

In case as an input you use JDBC Reader, then you can simply add an SQL query to select only 100 first rows.

But If input is a text/excel/csv file, I would recommend 2 workarounds: either to prepare a file with only 100 rows in advance, or to add a column to file with row number and after that use a condition step that will send to profiling step only first 100 rows, for instance.

Regards,
Victoria