Obtaining `_uuid` column from `kobo_data()` when asset is a repeat table

[Nova-Scotia]

Thanks for the great package, really happy to be able to pull my survey data in R. I'm wondering if there is a way to obtain the _uuid column from data within a repeat group.

If I download my survey data as an xls, within the repeat group, I can see the field _uuid, which can be used to uniquely identify records for post-processing and data cleaning. However, this field does not import with kobo_data. It does come in with the main survey table, just not with the repeats.

[dickoa]

Hi @Nova-Scotia
I hope all is well. Sorry for the delay in getting back to you. Ideally, you could just merge the data. I could explore adding it in the children's tables too.

library(tidyverse)
library(robotoolbox)
library(dm)

asset <- kobo_asset("xxxxxxxxxxxxxxxxxx")
asset
## <robotoolbox asset>  xxxxxxxxxxxxxxxxxx
##   Asset name: test_repeat
##   Asset type: survey
##   Asset owner: dickoa
##   Created: 2021-06-22 14:00:20
##   Last modified: 2024-03-09 09:47:08
##   Submissions: 7

df <- kobo_data(asset)
df
## ── Metadata ─────────────────────────────────────────────
## Tables: `main`, `household_characteristics`
## Columns: 32
## Primary keys: 2
## Foreign keys: 1
glimpse(df)
## > glimpse(df)
## dm of 2 tables: `main`, `household_characteristics`

## ─────────────────────────────────────────────────────────

## Table: `main`
## Primary key: `_index`

## Rows: 7
## Columns: 26
## $ start                           <dttm> 2021-06-22 14:21:16, …
## $ end                             <dttm> 2021-06-22 14:21:38, …
## $ today                           <date> 2021-06-22, 2021-06-2…
## $ username                        <chr> "username not found", …
## $ deviceid                        <chr> "enketo.unhcr.org:f88g…
## $ phonenumber                     <chr> "phonenumber not found…
## $ audit                           <lgl> NA, NA, NA, NA, NA, NA…
## $ name                            <chr> "Lebron", "dzzrzrz", "…
## $ household_size                  <int> 2, 4, 3, 2, 3, 3, 3
## $ `__version__`                   <chr> "v4MgWCMfqUmdwwzWDoqoGH…
## $ `_index`                        <int> 1, 2, 3, 4, 5, 6, 7
## $ `_id`                           <int> 14207739, 14207750, 14…
## $ simserial                       <chr> "simserial not found",…
## $ `_uuid`                         <chr> "96d01b64-cc44-4ff7-b3…
## $ `_validation_status`            <chr> NA, NA, NA, NA, NA, NA…
## $ `_xform_id_string`              <chr> "aEnSVDdSw2qvd85wddw…
## $ `_submitted_by`                 <lgl> NA, NA, NA, NA, NA, NA…
## $ instanceID                      <chr> "uuid:96d01b64-cc44-4f…
## $ uuid                            <chr> "0a02f5a3d0764ae584e3b…
## $ `_submission_time`              <dttm> 2021-06-22 14:21:46, 2…
## $ `_version_`                     <chr> "vkPLozwdwJpWWLZuynWKrL…
## $ `_status`                       <chr> "submitted_via_web", …
## $ subscriberid                    <chr> "subscriberid not foun…
## $ household_characteristics_count <dbl> 2, 4, 3, 2, 3, 3, 3
## $ rootUuid                        <chr> "uuid:96wdwd1b64-cc44-4f…
## $ `_attachments`                  <list> <NULL>, <NULL>, <NULL>…

## ─────────────────────────────────────────────────────────

## Table: `household_characteristics`
## Primary key: `_index`
## 1 outgoing foreign key(s):
##   `_parent_index` -> `main$_index` no_action

## Rows: 20
## Columns: 6
## $ hh_name              <chr> "Bronny", "Bryce", "ssss", "sss",…
## $ age                  <int> 16, 13, 7, 3, 3, 23, 24, 27, 54, …
## $ `_index`             <int> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11…
## $ `_parent_index`      <int> 1, 1, 2, 2, 2, 2, 3, 3, 3, 4, 4, …
## $ `_parent_table_name` <chr> "main", "main", "main", "main", "…
## $ `_validation_status` <chr> NA, NA, NA, NA, NA, NA, NA, NA, N…

dm_select(df, main, "_index", "uuid") |>
  dm_flatten_to_tbl(.start = household_characteristics) |>
  glimpse()
## Rows: 20
## Columns: 7
## $ hh_name              <chr> "Bronny", "Bryce", "ssss", "sss",…
## $ age                  <int> 16, 13, 7, 3, 3, 23, 24, 27, 54, …
## $ `_index`             <int> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11…
## $ `_parent_index`      <int> 1, 1, 2, 2, 2, 2, 3, 3, 3, 4, 4, …
## $ `_parent_table_name` <chr> "main", "main", "main", "main", "…
## $ `_validation_status` <chr> NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ uuid                 <chr> "0a92f5a3d0wdwd4ae583251083a8666…
## > 

You could learn more about manipulating and join dmobjects/tables here:

https://dm.cynkra.com/articles/tech-dm-join.html
https://dm.cynkra.com/articles/tech-dm-keyed.html