Skip to Content

Changes for page 13 Structure Mapping

Last modified by Artur on 2025/09/10 11:19
From version 6.1
edited by Helena
on 2025/06/16 15:30
Change comment: There is no comment for this version
To version 4.18
edited by Helena
on 2025/06/16 15:19
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -225,7 +225,7 @@
225 225  
226 226  The input 'G' matches on the last rule which is used as a catch-all or default in this example.
227 227  
228 -=== 13.6.2 Substrings ===
228 +=== 13. Substrings ===
229 229  
230 230  Substrings provide an alternative to regular expressions where the required section of an input value can be described using the number of the starting character, and the length of the substring in characters. The first character is at position 1.
231 231  
... ... @@ -531,40 +531,45 @@
531 531  |(% style="width:202px" %)Input INDICATOR|(% style="width:197px" %)Valid From/ Valid To|(% style="width:227px" %) Output OBS_CONF
532 532  |(% style="width:202px" %)XULADS|(% style="width:197px" %) 2008/2010|(% style="width:227px" %)С
533 533  
534 -=== 13.10.4 Time mapping ===
534 +=== 13.10.4  Time mapping ===
535 535  
536 -This use case is to create a [[time period>>doc:sdmx:Glossary.Time period.WebHome]] from an input that does not respect [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Time Formats.
536 +This use case is to create a time period from an input that does not respect SDMX Time Formats.
537 537  
538 -The [[Component>>doc:sdmx:Glossary.Component.WebHome]] Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details:
538 +The Component Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details:
539 539  
540 -(% style="width:652.294px" %)
541 -|(% style="width:139px" %)Source Value|(% style="width:165px" %)Source Mapping|(% style="width:182px" %)Target Frequency|(% style="width:163px" %)Output
542 -|(% style="width:139px" %)18/07/1981|(% style="width:165px" %)dd/MM/yyyy|(% style="width:182px" %)A|(% style="width:163px" %)1981
540 +|Source Value|Source Mapping|Target Frequency|Output
541 +|18/07/1981|dd/MM/yyyy|A|1981
543 543  
544 -When the target frequency is based on another target [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] value, in this example the value of the FREQ [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] in the target [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]].
543 +When the target frequency is based on another target Dimension value, in this example the value of the FREQ Dimension in the target DSD.
545 545  
546 -(% style="width:658.294px" %)
547 -|(% style="width:143px" %)Source Value|(% style="width:163px" %) Source Mapping|(% style="width:176px" %)Target Dimension|(% style="width:173px" %)Frequency Output
548 -|(% style="width:143px" %)18/07/1981|(% style="width:163px" %)dd/MM/yyyy|(% style="width:176px" %)FREQ|(% style="width:173px" %)1981-07-18 (when FREQ=D)
545 +Source Value Source Mapping Target Frequency Output
549 549  
550 - When the source is a numerical format.
547 +Dimension
551 551  
552 -(% style="width:658.294px" %)
553 -|(% style="width:143px" %)Source Value|(% style="width:163px" %) Start Period|(% style="width:176px" %)Interval|(% style="width:176px" %)Target FREQ|(% style="width:173px" %) Output
554 -|(% style="width:143px" %)1589808220|(% style="width:163px" %)1970|(% style="width:176px" %) millisecond|(% style="width:176px" %)M|(% style="width:173px" %)2020-05
549 +|18/07/1981 dd/MM/yyyy FREQ| |1981-07-18 (when FREQ=D)
550 +| When the source is a numerical format| |
551 +|Source Value Start Period Interval|(((
552 +Target
555 555  
554 +FREQ
555 +)))|Output
556 +|1589808220 1970 millisecond|M|2020-05
557 +
556 556  When the source frequency is lower than the target frequency additional information 3568 can be provided for resolve to start of period, end of period, or mid period, as shown 3569 in the following example:
557 557  
558 -(% style="width:666.294px" %)
559 -|(% style="width:131px" %) Source Value|(% style="width:143px" %)Source Mapping|(% style="width:149px" %)Target Dimension|(% style="width:114px" %)Frequency|(% style="width:126px" %)Output
560 -|(% style="width:131px" %)1981|(% style="width:143px" %)yyyy|(% style="width:149px" %)D – End of Period|(% style="width:114px" %) |(% style="width:126px" %)1981-12-31
560 + Source Value Source Mapping Target Frequency Output
561 561  
562 -When the start of year is April 1^^st^^ the Structure (% style="color:#e74c3c" %)Map(%%) has YearStart=04-01:
562 +Dimension
563 563  
564 -(% style="width:666.294px" %)
565 -|(% style="width:131px" %) Source Value|(% style="width:143px" %)Source Mapping|(% style="width:149px" %)Target Dimension|(% style="width:114px" %)Frequency|(% style="width:126px" %)Output
566 -|(% style="width:131px" %)1981|(% style="width:143px" %)yyyy|(% style="width:149px" %)D – End of Period|(% style="width:114px" %) |(% style="width:126px" %)1982-03-31
564 + 1981 yyyy D – End of Period 1981-12-31
567 567  
566 +
567 +When the start of year is April 1^^st^^ the Structure Map has YearStart=04-01:
568 +
569 + Source Value Source Mapping Target Frequency Output
570 +
571 +Dimension
572 +
568 568  ----
569 569  
570 570  {{putFootnotes/}}