Mappings values in DET config file

Developers
1

Hi all,
trying to explore the best way to transform data using mapping values in DET Config file

tried adding mappings tab as well as three columns that is; Mapping Name, Source, and Destination.
This seems not to work, any ideas on this

2

Hi

What version of the DET are you using? (commcare-export --version)

The mapping should work as you describe. Perhaps check your configuration against the docs here: DET Tips and Tricks - CommCare Public - CommCare Public

3

Hi Simon,

I am having an Issue with mapping DET excel config query file with two sheets, with the parent table and child table. It works fine when I am mapping values in only one sheet.

Let me know how this can be fixed when handling DET config file with two sheets parent sheet and with a child sheet containing repeat groups data

4

Hi

Mappings do with with multiple sheets. You need to have a single Mappings sheet which contains all the mapping for all sheets.