Representation Map - Revision history

Plazarou: /* Mapping a Component Based on Another Component's Value */

2025-04-25T15:03:37Z

‎Mapping a Component Based on Another Component's Value

Plazarou: /* Mapping a Component Based on Another Component's Value */

2025-04-25T15:03:17Z

‎Mapping a Component Based on Another Component's Value

Plazarou: /* Mapping a Component Based on Another Component's Value */

2025-04-25T15:02:54Z

‎Mapping a Component Based on Another Component's Value

Plazarou: /* Mapping a Component Based on Another Component's Value */

2025-04-25T15:01:35Z

‎Mapping a Component Based on Another Component's Value

Plazarou: /* Mapping a Component Based on Another Component's Value */

2025-04-25T14:47:53Z

‎Mapping a Component Based on Another Component's Value

Plazarou: /* Mapping a Component Based on Another Component's Value */

2025-04-25T14:46:07Z

‎Mapping a Component Based on Another Component's Value

Plazarou: /* Mapping a Component Based on Another Component's Value */

2025-04-25T14:44:59Z

‎Mapping a Component Based on Another Component's Value

Plazarou: /* Mapping a Component Based on Another Component's Value */

2025-04-25T14:43:15Z

‎Mapping a Component Based on Another Component's Value

Plazarou: /* Mapping a Component Based on Another Component's Value */

2025-04-25T14:39:45Z

‎Mapping a Component Based on Another Component's Value

Plazarou: /* Mapping a Component Based on Another Component's Value */

2025-04-25T14:37:56Z

‎Mapping a Component Based on Another Component's Value

@@ Line 277: / Line 277: @@
 ! style="text-align: left;" colspan="2" | Target
 |-
-! style="text-align: left; min-width: 100px;" | OBS_VALUE !! style="text-align: left; min-width: 150px;" | OBS_STATUS !! OBS_VALUE !! OBS_STATUS
+! style="text-align: left; min-width: 150px;" | OBS_VALUE !! style="text-align: left; min-width: 150px;" | OBS_STATUS !! style="text-align: left; min-width: 150px;" | OBS_VALUE !! style="text-align: left; min-width: 150px;" | OBS_STATUS
 |-
 | <blank>  || <any value> || <blank>  || M

@@ Line 277: / Line 277: @@
 ! style="text-align: left;" colspan="2" | Target
 |-
-! style="min-width: 200px;" | OBS_VALUE !! style="min-width: 200px;" | OBS_STATUS !! OBS_VALUE !! OBS_STATUS
+! style="text-align: left; min-width: 100px;" | OBS_VALUE !! style="text-align: left; min-width: 150px;" | OBS_STATUS !! OBS_VALUE !! OBS_STATUS
 |-
 | <blank>  || <any value> || <blank>  || M

@@ Line 273: / Line 273: @@
 * For all other cases, copy OBS_VALUE as-is to the target and copy the OBS_STATUS as-is to the target
-{| class="wikitable" style="text-align: left;"
+{| class="wikitable"
-! colspan="2" | Source
+! style="text-align: left;" colspan="2" | Source
-! colspan="2" | Target
+! style="text-align: left;" colspan="2" | Target
 |-
 ! style="min-width: 200px;" | OBS_VALUE !! style="min-width: 200px;" | OBS_STATUS !! OBS_VALUE !! OBS_STATUS

@@ Line 272: / Line 272: @@
 * If the OBS_VALUE is blank, the OBS_STATUS in the target should be set to "M"
 * For all other cases, copy OBS_VALUE as-is to the target and copy the OBS_STATUS as-is to the target
 Create a Structure Map which should perform all the other mappings you may require, however there should be no mappings for OBS_VALUE and OBS_STATUS, except for a combination map. This should declare a mapping of OBS_VALUE:OBS_STATUS to OBS_VALUE:OBS_STATUS and this should be assigned to the representation map previously created.

@@ Line 278: / Line 278: @@
 mappings need to be created (step 3 of the Representation Map wizard).  The first mapping should map "nothing" (i.e. no value) to nothing in the target, as well as mapping "anything" (a regex) to the letter "M".  This covers the case of where if the OBS_VALUE is blank, the OBS_STATUS is set to "M".
-The second mapping should map "anything" (as a RegEx in a capture group) to the target for both the elements.  The two mappings in the FMR UI will look like the following:
+The second mapping should map "anything" (as a RegEx in a capture group) to the target for both the elements. Note that in the targets the values of the appropriate capture group should be used. So this is \1 for the target string (the OBS_VALUE) and \2 for the target codelist (the OBS_STATUS value).
 [[File:RepMap.png|Mappings |900px]]

@@ Line 280: / Line 280: @@
 The second mapping should map "anything" (as a RegEx in a capture group) to the target for both the elements.  The two mappings in the FMR UI will look like the following:
-[[File:SDMX3 RepMap.png|Mappings |600px]]
+[[File:RepMap.png|Mappings |900px]]
-For completeness, an example of the Representation Map in SDMX-ML format is shown below:
+For completeness, the SDMX-ML form of the above is:
 <pre>
 <str:RepresentationMap agencyID="TEST_ACY" id="REP1" version="1.0">

← Older revision		Revision as of 14:43, 25 April 2025
Line 275:		Line 275:
	Create a Structure Map which should perform all the other mappings you may require, however there should be no mappings for OBS_VALUE and OBS_STATUS, except for a combination map. This should declare a mapping of OBS_VALUE:OBS_STATUS to OBS_VALUE:OBS_STATUS and this should be assigned to the representation map previously created.		Create a Structure Map which should perform all the other mappings you may require, however there should be no mappings for OBS_VALUE and OBS_STATUS, except for a combination map. This should declare a mapping of OBS_VALUE:OBS_STATUS to OBS_VALUE:OBS_STATUS and this should be assigned to the representation map previously created.

−	The complication in the above is creating the representation map.	+	The complication in the above is creating the representation map. This will maps 2 sources to 2 targets. For the source, the first element will be "Free Text" (for the OBS_VALUE) and the second element will be a coded representation. The target elements should match these.
		+
		+	2 mappings need to be created (step 3 of the Representation Map wizard). The first mapping should map "nothing" (i.e. no value) to nothing in the target, as well as mapping "anything" (a regex) to the letter "M". This covers the case of where if the OBS_VALUE is blank, the OBS_STATUS is set to "M".
		+	The second mapping should map "anything" (as a RegEx in a capture group) to the target for both the elements. The two mappings in the FMR UI will look like the following:
		+
		+

← Older revision		Revision as of 14:39, 25 April 2025
Line 274:		Line 274:

	Create a Structure Map which should perform all the other mappings you may require, however there should be no mappings for OBS_VALUE and OBS_STATUS, except for a combination map. This should declare a mapping of OBS_VALUE:OBS_STATUS to OBS_VALUE:OBS_STATUS and this should be assigned to the representation map previously created.		Create a Structure Map which should perform all the other mappings you may require, however there should be no mappings for OBS_VALUE and OBS_STATUS, except for a combination map. This should declare a mapping of OBS_VALUE:OBS_STATUS to OBS_VALUE:OBS_STATUS and this should be assigned to the representation map previously created.
		+
		+	The complication in the above is creating the representation map.
		+
		+
		+	For completeness, an example of the Representation Map in SDMX-ML format is shown below:
		+	<pre>
		+	<str:RepresentationMap agencyID="TEST_ACY" id="REP1" version="1.0">
		+	<com:Name xml:lang="en">REP1</com:Name>
		+	<com:Description xml:lang="en">Combination mapping</com:Description>
		+	<str:SourceDataType>String</str:SourceDataType>
		+	<str:SourceCodelist>urn:sdmx:org.sdmx.infomodel.codelist.Codelist=TEST_ACY:CL_OBS_STATUS(1.0)</str:SourceCodelist>
		+	<str:TargetDataType>String</str:TargetDataType>
		+	<str:TargetCodelist>urn:sdmx:org.sdmx.infomodel.codelist.Codelist=TEST_ACY:CL_OBS_STATUS(1.0)</str:TargetCodelist>
		+	<str:RepresentationMapping>
		+	<str:SourceValue/>
		+	<str:SourceValue isRegEx="true">(.*)</str:SourceValue>
		+	<str:TargetValue/>
		+	<str:TargetValue>M</str:TargetValue>
		+	</str:RepresentationMapping>
		+	<str:RepresentationMapping>
		+	<str:SourceValue isRegEx="true">(.*)</str:SourceValue>
		+	<str:SourceValue isRegEx="true">(.*)</str:SourceValue>
		+	<str:TargetValue>\1</str:TargetValue>
		+	<str:TargetValue>\2</str:TargetValue>
		+	</str:RepresentationMapping>
		+	</str:RepresentationMap>
		+	</pre>

@@ Line 269: / Line 269: @@
 Consider the simple scenario where a source and target DSD both have an OBS_VALUE and OBS_STATUS (a coded attribute at the Observation level). We want to create a mapping, where if a dataset specifies an observation with a missing (blank) OBS_VALUE the OBS_STATUS will be set to the value "M" (missing).
-Create a Representation Map - this is going to map both OBS_VALUE and OBS_STATUS. It will have 2 conditions:
+Create a Representation Map which will map both OBS_VALUE and OBS_STATUS. It will have 2 conditions:
 * If the OBS_VALUE is blank, the OBS_STATUS in the target should be set to "M"
 * For all other cases, copy OBS_VALUE as-is to the target and copy the OBS_STATUS as-is to the target
 Create a Structure Map which should perform all the other mappings you may require, however there should be no mappings for OBS_VALUE and OBS_STATUS, except for a combination map. This should declare a mapping of OBS_VALUE:OBS_STATUS to OBS_VALUE:OBS_STATUS and this should be assigned to the representation map previously created.