Compromise a qvf file to the first 100 records

[Anonymous]

Hello,

I have a saved application and i need to compromise it to a smaller .qvf as i need to send the first 100 record by email

Do you have an idea how can i load the first 100 record from the data load editor without using a script?

Thank you,

[felipedl]

Hi Mustafa,

Didn't quite understand what you meant without using a script but on the data load editor, for each table you have on your final model, you can use the First [Number of rows], in your case First 100, to get only the first 100 loaded lines per table.

Something like:

First 100

Table:

Load

     *

From [Whatever];

Felipe.

[rwunderlich]

In the script editor, you can enter the debugger and do a limited load of 100 rows.   If you can't reload, I'm not sure how you can reduce.

-Rob

[dwforest]

You could possibly use Rank() function to determine first 100; they apply a filter to a table object and export data....

[balabhaskarqlik]

Not possible, without using Load script to decrease the record count of .QVF file to 100 records.