topic Reduced Document Name (Loop and reduce) in QlikView

Reduced Document Name (Loop and reduce)

Fri, 30 Oct 2015 09:10:09 GMT

Hi All,

I am trying to create a reduce and loop task on publisher where I create a qvw for each store that we have. The task itself works fine but the formatting of the document is incorrect.

In the Reduced Document Name I have entered the following:

%SourceDocumentName%%DocumentField,Store No%

And the qvw's are created successfully naming is incorrrect e.g. 'ENDVtest14' instead of 'ENDVtest00014'.

My question is how do I format the Store No so that it pads out with preceding zeroes?

Thanks,

Brian

Re: Reduced Document Name (Loop and reduce)

Gysbert_Wassenaar — Mon, 02 Nov 2015 13:08:07 GMT

I think you have to create a new field in the script of the qlikview document for that purpose: Text(Repeat('0',5-len([Store No]))&[Store No]) as PaddedStoreNo

Re: Reduced Document Name (Loop and reduce)

Wed, 04 Nov 2015 10:11:27 GMT

Thanks gwassenaar‌ worked a treat!