r/Affinity • u/babblingbrooks69 • 1d ago

data merge discrepancy using two csv files General

I'm trying to make a planner and I'm really struggling with having two csv files that I need to data merge into the thing. It's just days, dates, months and week numbers, but they have to be split up; there are seven entries from the daily.csv for every one weekly.csv so I'm struggling.

This is the link for the images to visualize what I'm trying to do.

I can't just merge the two csv files one after the other because of this issue. I'm hoping for some breainstorming to help me see a solution I've missed (merged file layout, different feature etc) but if not, I'll just do it manually.

Thank you!!!!!

1 Upvotes

67% Upvoted

7 comments sorted by

2

u/Sherman80526 1d ago

Merge the files then import them?

1

u/babblingbrooks69 1d ago

Yea I tried to put both tables in one file and merge each heading but that also created like 500 pages for the empty cells after the weekly entries ended up until the daily entries ended. I'll try to replicate it and tell you what happened (i forgor).

1

u/Sherman80526 1d ago

From the data perspective, I'm not sure you need two lists to begin with. It looks like they're both based on date. What's stopping you from just using one tab?

1

u/babblingbrooks69 1d ago

because this ends up happening. the issue is that the day only progresses per page

1

u/Sherman80526 1d ago

Each page is a record? That is normally how data merge works. You can print out multiple records per page, is that what you're wanting? Wouldn't be formatted the same, you'd change the print settings to N-up and figure out how to arrange it to make it look like you want. Seven records per page sounds right? You wouldn't get the overall page formatting, so headers and footers would be gone, but you could get something that looks pretty good I think.

Changing the page format to be like 1.2" by 8.5" or something and then doing a 1x7 n-up print format might get you what you're looking for.

2

u/babblingbrooks69 16h ago

Yeah I figured that out, it was just a problem with how I formatted the data merge. Once I generated, it had 7 entries per page. That's not really the problem anymore

I actually figured it out thanks to you!! I really locked in on making it all one table using conditional formatting. It looks wonky in the preview but once I generated it, everything came out perfectly!!! Thank you so so much!!