Reduced Document Name (Loop and reduce)

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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

[#3]

Thanks gwassenaar‌ worked a treat!