Hello, I need help with a project I’m working on, and I’d like some help with a problem I’m facing.
I created a questionnaire that has 5 repeat groups, and everything is working perfectly, in the registrations, submissions, and everything else.
The problem is that I have to generate a report with this information. I downloaded the data to Excel and did a mail merge in Word, but I can only do the procedure on the main page, but I have to copy and paste all the data from the other 5 tabs.
I would like to know if there is a more practical and automated way because it is becoming very unfeasible to do this process of including the repeat data manually.
I would appreciate anyone who can help me.
Hi @jovitosam,
The easiest way i would suggest if you are not familiar with any type of programming language, Power Query, use it in Excel or Power Query how ever you want. In the main tab there is a column called “_index” and other sheets there is another column called as “_parent_index”. So This to id is referes the same form, what you can easily do is go to Power Query, import all your data and merge them by using the “_index” and “_parent index” columns, but this will increase data redundancy. If you would like to generate a report, search for the “Relationship in SQL” so it will help you alot to understand the system and decrease your workload for the report.
1 Like
@jovitosam, here is one workaround using the Excel Power Query as advised by @osmanburcu:
I know this solution, but for those who work with a large amount of data it is not viable, because it generates many repeated lines of information. But I appreciate your attention.
For Large amount of data sets you can use python and pandas library in a much shorter durations.
