Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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
You could possibly use Rank() function to determine first 100; they apply a filter to a table object and export data....
Not possible, without using Load script to decrease the record count of .QVF file to 100 records.