Jump to content

Recommended Posts

Posted

I am using Publisher 2 in order to create 10 different labels per page with data that I get from a spreadsheet. My spreadsheet has about 200 rows of data and I want each row to be a new label, 10 different labels per page. In the end, I want to have 10 pages with 10 labels per page.

I have created the text and linked the text to the different rows in my csv file. All is fine until I  push the button "Generate" in the Data Merge window. Each row is repeated ten times for every page.

That is not what I want.

I want ten pages with ten different labels per page. Anyone that knows what I am doing wrong?

Posted

Hi @gorito and welcome to the forums,

Could you upload a screenshot showing how your page is laid out and showing your Layers panel expanded so we can see how you have everything set up?

Affinity Designer 2.6.3 | Affinity Photo 2.6.3 | Affinity Publisher 2.6.3
MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse
HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse

Posted

Use the layout tool for data merging.image.png.0bcadff2d79881d4c3ac2787300e2f22.png
Use it to create a layout mask with one column and ten rows.
Insert the field variable in the first row.
Don't be surprised, the same content is displayed in all ten rows. When you now start the merge, the result will look as you would expect.

EDIT: Is each line value in the .csv file in a separate line or are the values only separated by a comma (or other separator)? In the latter case, the result would look as you described.

 

MAC mini M4 | MacOS Sequoia 15.5 | 16 GB RAM | 256 GB SSD 
AMD Ryzen 7 5700X | Sapphire Nitro+ RX 9060 XT 16 GB  | 32 GB DDR4 3200MHz | Windows 11 Pro 24H2 (26100.4351)

Windows 11 Pro on VMWare Virtual Machine (on Mac)
Affinity Suite V 2.6.3 & Beta 2.6 (latest)
Interested in a free (selfhosted) PDF Solution? Have a look at Stirling PDF

No backup, no pity.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.