Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have a few qvw's that contain data for multiple companies (companies are a key across the qvw). We need to copy these qvw files to single company qvw files after the extract (so as not to do an extract from source data again). I can schedule the qvw to be copied to another qvw name, but then how can I write a script to strip out the relevent company for this new copied one? What is the best method?
Regards,
John
The BEST method is probably to use QlikView Publisher. On the task, there is a Reduce tab. Do a loop and reduce on the Customer field. That should create one document per Customer.
If you don't have QlikView Publisher, and you only have a few customers, you might be able to do it like this:
BINARY MainDocument.qvw;
INNER JOIN (MainTable)
LOAD 'Bob Jones' as Customer
AUTOGENERATE 1;
And repeat with a separate QVW and script for every customer.
There are probably other approaches that would work too.
Thanks for the advice John. I don't have publisher, but Qlikviw professional. I am testing out your solution.
Thanks,
John