Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r079

...

  1. First, you must split the column based on the cell value's delimiter. Note that the following transformation uses the 

    d-s-itemlang
    itempattern
     {delim} to locate the delimiter in the cell value. This delimiter is either a dash or a slash.

    D trans
    p03Value`{delim}`
    Typestep
    p01NameColumn
    p01ValuecontractDate
    p02NameOption
    p02Valueby Delimiter
    p03NameDelimiter
    SearchTermSplit by delimiter

  2. Create the following three conditional transformations for extracting the day, month, or year values based on the value in the Region column. Here is the transformation to acquire the year values:

    D trans
    p03Value'EU'
    p06NameValue 2
    p01NameCondition type
    p06ValuecontractDate3
    p03NameCase 1
    p07Value'CHN'
    p04ValuecontractDate3
    SearchTermconditions
    p07NameCase 3
    Typestep
    p05NameCase 2
    p01ValueCase on single column
    p02NameColumn to evaluate
    p02ValueRegion
    p05Value'USA'
    p04NameValue 1
    p08ValuecontractDate1
    p08NameValue 1

  3. For month:

    D trans
    p03Value'EU'
    p06NameValue 2
    p01NameCondition type
    p06ValuecontractDate1
    p03NameCase 1
    p07Value'CHN'
    p04ValuecontractDate2
    SearchTermconditions
    p07NameCase 3
    Typestep
    p05NameCase 2
    p01ValueCase on single column
    p02NameColumn to evaluate
    p02ValueRegion
    p05Value'USA'
    p04NameValue 1
    p08ValuecontractDate2
    p08NameValue 1

     

  4. For day:

    D trans
    p03Value'EU'
    p06NameValue 2
    p01NameCondition type
    p06ValuecontractDate2
    p03NameCase 1
    p07Value'CHN'
    p04ValuecontractDate1
    SearchTermconditions
    p07NameCase 3
    Typestep
    p05NameCase 2
    p01ValueCase on single column
    p02NameColumn to evaluate
    p02ValueRegion
    p05Value'USA'
    p04NameValue 1
    p08ValuecontractDate3
    p08NameValue 1

  5. You can now bring together these three columns:

    D trans
    p03ValuenewDate
    Typestep
    p01NameColumns
    p01Valueday, month, year
    p02NameSeparator
    p02Value'/'
    p03NameNew column name
    SearchTermMerge columns

  6. You now have your new date column. You may need to reformat it into a preferred format.
  7. Delete the columns that were created during this process.