cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Problem with document generation tagging excel repeating rows

Jump to solution

Hi all,

I have recently had to change a workflow to the newer version of DocGen but I am struggling to work out why my collection data is not being listed properly in the Excel file.

I have followed a blog posted by Patrick Hosch‌ (https://community.nintex.com/community/tech-blog/blog/2017/04/19/document-generation-just-got-a-majo...) but I don't see any data when the file is built.

I have tried multiple ways of doing this; selecting a range of cells for the data (which shows nothing), and selecting the top row of the table (which shows a single row of data), but I am lost in this at the moment.

What I have is 5 columns of data which can be variable in the number of rows (but up to a max of 5) and each row has different data; Date, Reference, and other data.

There are other non-collection variables that do show on the Excel file but my main concern is why the collection data doesn't show.

Edit: I have placed the Row Start variable from the Table fields in the first row (date Sample Drawn) under the header and then I selected multiple rows beneath that row for the separate columns. This showed nothing in the Excel file.

I then selected one specific cell in each column and it showed the first element from each of the collection variables.

Any help would be appreciated.

Date Sample DrawnReferenceTypePeriodChargeStrengthVolume
       
       
       

Regards,

Paul 

Labels: (1)
Reply
1 Reply
Workflow Hero

Re: Problem with document generation tagging excel repeating rows

Jump to solution

This completely was down to the way to tag Excel files and my lack of understanding.

For a repeating set of data to show in Excel I have to highlight the complete row of columns to be used in the table and tag that as SampleDataRow_Start (my example). Then, I had to select each "top" row of the columns that I want for the repeating data and tag them accordingly; Date, Reference, etc.

I got this heads up from a great resource based in Audtralia - so, thanks to him (‌) !

Cheers.

Reply