Changes for page 12 Validation and Transformation Language (VTL)
Last modified by Artur on 2025/09/10 11:19
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -18,7 +18,7 @@ 18 18 19 19 This section does not explain the VTL language or any of the content published in the VTL guides. Rather, this is a description of how the VTL can be used in the SDMX context and applied to SDMX artefacts. 20 20 21 -== 12.2 References to SDMX artefacts from VTL statements ==21 +== 12.2 References to SDMX artefacts from VTL statements == 22 22 23 23 === 12.2.1 Introduction === 24 24 ... ... @@ -116,7 +116,7 @@ 116 116 117 117 by omitting all the non-essential parts would become simply: 118 118 119 -> DFR : =DF1 + DF2119 +> DFR : = DF1 + DF2 120 120 121 121 The references to the Codelists can be simplified similarly. For example, given the non-abbreviated reference to the Codelist AG:CL_FREQ(1.0.0), which is{{footnote}}Single quotes are needed because this reference is not a VTL regular name. 19 Single quotes are not needed in this case because CL_FREQ is a VTL regular name.{{/footnote}}: 122 122 ... ... @@ -452,16 +452,17 @@ 452 452 453 453 > ‘DF2(1.0.0)/GDPPERCAPITA.USA’ <- expression11; ‘DF2(1.0.0)/GDPPERCAPITA.CANADA’ <- expression12; 454 454 > … … … 455 -> ‘DF2(1.0.0)/POPGROWTH.USA’ <- expression21;455 +> ‘DF2(1.0.0)/POPGROWTH.USA’ <- expression21; 456 456 > ‘DF2(1.0.0)/POPGROWTH.CANADA’ <- expression22; 457 457 > … … … 458 458 459 459 As said, it is assumed that these VTL derived Data Sets have the TIME_PERIOD as the only identifier. In the mapping from VTL to SMDX, the Dimensions INDICATOR and COUNTRY are added to the VTL data structure on order to obtain the SDMX one, with the following values respectively: 460 460 461 -VTL dataset INDICATOR value COUNTRY value462 - 461 +> VTL dataset INDICATOR value COUNTRY value 462 +> 463 463 > ‘DF2(1.0.0)/GDPPERCAPITA.USA’ GDPPERCAPITA USA 464 464 > ‘DF2(1.0.0)/GDPPERCAPITA.CANADA’ GDPPERCAPITA CANADA … … … 465 +> 465 465 > ‘DF2(1.0.0)/POPGROWTH.USA’ POPGROWTH USA 466 466 > ‘DF2(1.0.0)/POPGROWTH.CANADA’ POPGROWTH CANADA 467 467 > … … …