Daniel Bernardes

Ciao Gaspare, Questo e il mismo problema che c'o. Dovevi combinare i tuoi fogli in un solo. This is the same issue I had. You need to combine your spreadsheets into one.

Hi Affinity Team, Currently on Affinity Publisher one can have multiple sources for data merge but only one can be used at a time so they are interchangeable data sources. My feature request would be to be able to use multiple data sources concomitantly on data merge. For example: I created a catalog of people and services for a company. Each set {People, Services} has its own sub-set of characteristics {Name, Department, Expertise, Years of Experience, Etc} {Name, Department, Description, Duration, Etc}. Having to combine both into one data source leads to data duplication for one of the sets into the other one unnecessarily. If I chose to set my data on People, each line (person) will have a complete set of Services making the database unnecessarily big. The workaround today is to link the using formulas but its not ideal. Thank you, Daniel

Thanks Bruce, I've done this workaround and I'm happy to report that AP can handle calculated fields so I can link my link the data instead of copy pasting in each cell. At least this way I know that the information lives in only one place and gets referenced to others. Still going to place a request for multiple data merges.

Yes Notepad++ is a great tool. But when merging the two tables, I'll have to duplicate data on purpose to make it work. This is my current setup: Table 1 (Contact) Name Postition Contact details (phone, email, etc) Expertise Years of exp Image address (...) Table 2 (Service) Service name Service description Image address To merge them together, either each line in the Contact table has to incorporate all items in the Service table or the other way around. Do you see the issue? I'm not a fan of having data repeated on a database as the chances of mismatch are big. I'll try using formulas to replicate but I haven't tested how Affinity handles calculated fields.

Thank you Komatös, I was afraid of that. I guess the only workaround will be to merge the tables, it will create a lot of duplicated data but will have to do for now.

Hello, I am trying to merge information into my document on Affinity Publisher from two excel files. The first one always works well and I can insert the fields. When I add a second data source it shows on my data merge panel with the fields but when I try populating from that source nothing happens. I tried both using a second sheet on the same file as well as using two separate excel files with no result on either. I also made sure that my field names do not repeat on both sources. Any ideas? Thanks, Daniel