Changes for page 13 Structure Mapping
Last modified by Helena on 2025/09/10 11:19
Summary
-
Page properties (2 modified, 0 added, 0 removed)
-
Attachments (0 modified, 0 added, 8 removed)
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_295af259.jpg
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_4ec4bb31.gif
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_59eee18f.gif
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_6dbf7f.gif
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_8c1afe2b.gif
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_a3215c79.jpg
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_ab51b44a.jpg
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_dbe68698.gif
Details
- Page properties
-
- Title
-
... ... @@ -1,1 +1,0 @@ 1 -13 Structure Mapping - Content
-
... ... @@ -1,6 +1,4 @@ 1 -{{box title="**Contents**"}} 2 -{{toc/}} 3 -{{/box}} 1 += 13 Structure Mapping = 4 4 5 5 == 13.1 Introduction == 6 6 ... ... @@ -18,7 +18,7 @@ 18 18 19 19 * Transforming received data into a common internal structure; 20 20 * Transforming reported data into the data collector's preferred structure; 21 -* Transforming unidimensional datasets^^[[ (% class="wikiinternallink wikiinternallink" %)^^43^^>>path:#sdfootnote43sym||name="sdfootnote43anc"]](%%)^^ to multi-dimensional; and19 +* Transforming unidimensional datasets^^[[^^43^^>>path:#sdfootnote43sym||name="sdfootnote43anc"]]^^ to multi-dimensional; and 22 22 * Transforming internal datasets with a complex structure to a simpler structure with fewer dimensions suitable for dissemination. 23 23 24 24 == 13.2 1-1 structure maps == ... ... @@ -33,7 +33,7 @@ 33 33 |Algeria|DZ|DZA 34 34 |American Samoa|AS|ASM 35 35 |Andorra|AD|AND 36 -|etc…| |34 +|etc…|| 37 37 38 38 Different source values can also map to the same target value, for example when deriving regions from country codes. 39 39 ... ... @@ -158,7 +158,7 @@ 158 158 |DZ|DZA 159 159 |AS|ASM 160 160 |AD|AND 161 -|etc…| 159 +|etc…| 162 162 163 163 A Representation Map mapping free text country names to an ISO 2-character Codelist could be similarly described: 164 164 ... ... @@ -169,7 +169,7 @@ 169 169 |"Great Britain"|GB 170 170 |"Ireland"|IE 171 171 |"Eire"|IE 172 -|etc…| 170 +|etc…| 173 173 174 174 Valuelists, introduced in SDMX 3.0, are equivalent to Codelists but allow the maintenance of non-SDMX identifiers. Importantly, their IDs do not need to conform to IDType, but as a consequence are not Identifiable. 175 175 ... ... @@ -180,7 +180,7 @@ 180 180 |Value|Locale|Name 181 181 |$|en|United States Dollar 182 182 |%|En|Percentage 183 -| |fr|Pourcentage181 +||fr|Pourcentage 184 184 185 185 Other characteristics of Representation Maps: 186 186 ... ... @@ -279,7 +279,7 @@ 279 279 280 280 Date and time formats are specified by date and time pattern strings based on Java's Simple Date Format. Within date and time pattern strings, unquoted letters from 'A' to 'Z' and from 'a' to 'z' are interpreted as pattern letters representing the components of a date or time string. Text can be quoted using single quotes (') to avoid interpretation. "''" represents a single quote. All other characters are not interpreted; they're simply copied into the output string during formatting or matched against the input string during parsing. 281 281 282 -Due to the fact that dates may differ per locale, an optional property, defining the locale of the pattern, is provided. This would assist processing of source dates, according to the given locale^^[[ (% class="wikiinternallink wikiinternallink" %)^^44^^>>path:#sdfootnote44sym||name="sdfootnote44anc"]](%%)^^. An indicative list of examples is presented in the following table:280 +Due to the fact that dates may differ per locale, an optional property, defining the locale of the pattern, is provided. This would assist processing of source dates, according to the given locale^^[[^^44^^>>path:#sdfootnote44sym||name="sdfootnote44anc"]]^^. An indicative list of examples is presented in the following table: 283 283 284 284 |English (en)|Australia (AU)|en-AU 285 285 |English (en)|Canada (CA)|en-CA ... ... @@ -325,7 +325,7 @@ 325 325 326 326 |Letter|Date or Time Component|Presentation|Examples 327 327 |G|Era designator|[[Text>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#text]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#text]]|AD 328 -|yy|Year short (upper case is Year of Week^^[[ (% class="wikiinternallink wikiinternallink" %)^^45^^>>path:#sdfootnote45sym||name="sdfootnote45anc"]](%%)^^)|[[Year>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#year]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#year]]|96326 +|yy|Year short (upper case is Year of Week^^[[^^45^^>>path:#sdfootnote45sym||name="sdfootnote45anc"]]^^)|[[Year>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#year]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#year]]|96 329 329 |yyyy|Year Full (upper case is Year of Week)|Year|1996 330 330 |MM|Month number in year starting with 1|Month|07 331 331 |MMM|Month name short|Month|Jul ... ... @@ -530,7 +530,7 @@ 530 530 531 531 The following representation mapping can be used to explicitly map each age to an output code. 532 532 533 -: 531 +: 534 534 535 535 ((( 536 536 |Source Input Free Text|Desired Output Code Id ... ... @@ -547,7 +547,7 @@ 547 547 548 548 __Regular Expression __Desired Output 549 549 550 -: 548 +: 551 551 552 552 ((( 553 553 |[0-2]|A ... ... @@ -558,7 +558,7 @@ 558 558 559 559 This use case is where a specific observation for a specific time period has an attribute 3468 value. 560 560 561 -: 559 +: 562 562 563 563 ((( 564 564 |Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF ... ... @@ -579,7 +579,7 @@ 579 579 580 580 The Component Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details: 581 581 582 -: 580 +: 583 583 584 584 ((( 585 585 |Source Value|Source Mapping|Target Frequency|Output ... ... @@ -590,18 +590,18 @@ 590 590 591 591 [[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_dbe68698.gif||alt="Shape12" height="1" width="273"]] 592 592 593 -: 594 -:: 591 +: 592 +:: 595 595 596 596 ((( 597 597 |Source Value|Source Mapping|Target Frequency Output Dimension 598 598 599 -|18/07/1981 dd/MM/yyyy|FREQ| |1981-07-18 (when FREQ=D)597 +|18/07/1981 dd/MM/yyyy|FREQ||1981-07-18 (when FREQ=D) 600 600 |(% rowspan="2" %)((( 601 601 __When the source is a numerical form__at 602 602 603 603 Source Value Start Period Interv 604 -)))| ||602 +)))||| 605 605 |al|((( 606 606 Target 607 607
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_295af259.jpg
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.helena - Size
-
... ... @@ -1,1 +1,0 @@ 1 -57.7 KB - Content
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_4ec4bb31.gif
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.helena - Size
-
... ... @@ -1,1 +1,0 @@ 1 -1.4 KB - Content
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_59eee18f.gif
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.helena - Size
-
... ... @@ -1,1 +1,0 @@ 1 -851 bytes - Content
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_6dbf7f.gif
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.helena - Size
-
... ... @@ -1,1 +1,0 @@ 1 -1.1 KB - Content
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_8c1afe2b.gif
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.helena - Size
-
... ... @@ -1,1 +1,0 @@ 1 -865 bytes - Content
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_a3215c79.jpg
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.helena - Size
-
... ... @@ -1,1 +1,0 @@ 1 -30.6 KB - Content
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_ab51b44a.jpg
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.helena - Size
-
... ... @@ -1,1 +1,0 @@ 1 -28.1 KB - Content
- SDMX 3-0-0 SECTION 6 FINAL-1.0_en_dbe68698.gif
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.helena - Size
-
... ... @@ -1,1 +1,0 @@ 1 -863 bytes - Content