Hi, greetings!
Can anyone help me in providing solution to get the Grouped Data in Google Spreadsheets with Parent ID and Index number as it is downloaded in CSV or Excel file in Kobo collect Data–>> Downloads section.
I have a data set where in we are looking for a number of persons trained and their basic details such as name, age, contact details, etc. Under repeated group for each training conducted.
I tried several ways, somehow the data spread vertically only in columns in Gsheet when refreshed with API connectors. But, I need it in two different sheets one for main data and the second sheet with grouped responses with Parent ID .
Hi @Kal_Lam Thank you for quick response. I haven’t tried with Excel Power Query. Basically, I need it in Google spreadsheet as I wanted to link the data with Google Data Studio for visualising.
@Kal_Lam, please create a sperate function “importRepeat()”, just like “importdata()”.
with importdata() we can import parent data (normal CSV file) in google sheet1. It’s already available.
and with importRepeat() we will import child data in google sheet2.
@PrashanthSJ,
I think its not available as of now. This is a very old discussion and nothing has happened till now.
you can use PowerBI. it automatically download 2 tables. parent and child. try once