Discussion Board for collaboration on QlikView Scripting.
I am trying to use the store statement to dump a table after a script, but have it product multiple text files based on a field.
Store Output into [\David\documents\text1.txt] (txt);
How can i get this script to make an individual text file for each Salesperson?
this should work:
for i = 0 to noofrows('Salespersontable')
let vSP = peek ('SalesPerson', $(i), 'Salespersontable');
Resident Temp1 where match(SalesPerson, '$(vSP)');
Store Output into [\David\documents\text$(vSP).txt] (txt);
drop table Output;