Changes for page 13 Structure Mapping
Last modified by Helena on 2025/09/10 11:19
Summary
-
Page properties (1 modified, 0 added, 0 removed)
-
Attachments (0 modified, 0 added, 1 removed)
Details
- Page properties
-
- Content
-
... ... @@ -39,9 +39,7 @@ 39 39 Different source values can also map to the same target value, for example when deriving regions from country codes. 40 40 41 41 (% style="width:674.294px" %) 42 -|(% style="width:284px" %)**Source Component: 43 -REF_AREA**|(% style="width:387px" %)**Target Component: 44 -REGION** 42 +|(% style="width:284px" %)**Source Component: REF_AREA**|(% style="width:387px" %)**Target Component: REGION** 45 45 |(% style="width:284px" %)FR|(% style="width:387px" %)EUR 46 46 |(% style="width:284px" %)DE|(% style="width:387px" %)EUR 47 47 |(% style="width:284px" %)IT|(% style="width:387px" %)EUR ... ... @@ -455,7 +455,22 @@ 455 455 456 456 === 13.10.1 Many to one mapping (N-1) === 457 457 458 -[[image:1747377208446-496.png]] 456 +(% style="width:762.294px" %) 457 +|(% style="width:474px" %)**Source**|(% style="width:284px" %)**Map To** 458 +|(% style="width:474px" %)((( 459 +**FREQ**="A" 460 +ADJUSTMENT="N" 461 +**REF_AREA**="PL" 462 +**COUNTERPART_AREA**="W0" 463 +REF_SECTOR="S1" 464 +COUNTERPART_SECTOR="S1" ACCOUNTING_ENTRY="B" 465 +STO="B5G" 466 +)))|(% style="width:284px" %)((( 467 +FREQ="A" 468 +REF_AREA="PL" 469 +COUNTERPART_AREA="W0" 470 +INDICATOR="IND_ABC" 471 +))) 459 459 460 460 The bold Dimensions map from source to target verbatim. The mapping simply specifies: 461 461 ... ... @@ -491,19 +491,18 @@ 491 491 |(% style="width:218px" %)4|(% style="width:448px" %)B 492 492 ))) 493 493 494 -If this mapping takes advantage of regular expressions it can be expressed in two rules: 507 +If this mapping takes advantage of regular expressions it can be expressed in two 3464 rules: 495 495 509 +__Regular Expression __Desired Output 510 + 496 496 ((( 497 497 (% style="width:675.294px" %) 498 -|(% style="width:219px" %)((( 499 -**Regular Expression** 500 -)))|(% style="width:453px" %)**Desired Output** 501 501 |(% style="width:219px" %)[0-2]|(% style="width:453px" %)A 502 502 |(% style="width:219px" %)[3-4]|(% style="width:453px" %)B 503 - 504 -(% style="color:inherit; font-family:inherit; font-size:max(21px, min(23px, 17.4444px + 0.462963vw))" %)13.10.3 Observation Attributes for Time Period 505 505 ))) 506 506 517 +=== 13.10.3 Observation Attributes for Time Period === 518 + 507 507 This use case is where a specific observation for a specific time period has an attribute 3468 value. 508 508 509 509 ((( ... ... @@ -556,7 +556,7 @@ 556 556 557 557 Dimension 558 558 559 - 1981 yyyy D – End of Period 1981-12-31 571 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_4ec4bb31.gif||alt="Shape13" height="173" width="555"]] 1981 yyyy D – End of Period 1981-12-31 560 560 561 561 When the start of year is April 1^^st^^ the Structure Map has YearStart=04-01: 562 562
- 1747377208446-496.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.helena - Size
-
... ... @@ -1,1 +1,0 @@ 1 -28.0 KB - Content