J-Transform YYYYMMDD to DD.MM.YYYY

J-Transform YYYYMMDD to DD.MM.YYYY

Similar to 'D-Transform YYYYMMDD to DD.MM.YYYY', if we have a date in YYYYMMDD format as shown in the image below, then it can be transformed to DD.MM.YYYY format.

Transform_YYYYMMDD_to_DD.MM.YYYY_1

In Mapper tab, select the 'J-Transform YYYYMMDD to DD.MM.YYYY' DF for the corresponding field.

Transform_YYYYMMDD_to_DD.MM.YYYY_2

 

Following image represents how Process Runner adapts the transformation on-the-go

MAT-DF-Trans-yy.mm.dd-DD.MM.YY-3

 

Next

P-Convert to absolute value (remove negative sign)