DSXchange

I think you just want to subtract your column value from 99999999 and then insert ":" as you have shown in the above example. Lets say that you have a value "83885269" DN_TIME_STAMP column. In transformer give a derivation something like this in a stage variable., say SV 99999999...

I think convert the date(in this case Current_Date()) into julian and perform the subtraction and then convert back into date.

Step 1: Do a picot for the column names Separate the column names as a data and do a pivot Expected ouput: Col1 Col2 Pivot_Index ID Sev1 0 ID Sev2 1 ID Sev3 2 Step 2 Do a pivot for the whole data Expected ouput: ID Pivot_Index Values ABC 0 0.45 ABC 1 1 ABC 2 1 PQR 0 0.45 PQR 1 1 PQR 2 2 XYZ 0 0.45 X...