DSXchange

I got a requirement to convert columns into rows and then based on column names set default values corresponding to key. Tried using vertical pivot option in pivot enterprise but not able to compare the name values to set default value Below is the example : Input : Key Name 1 ABC 1 DEF 1 GHI 1 JKL ...

Hi folks,

I have an input file which has 5 digit chars.

My requirement is to pad a character at the left most position and truncate the right most one. kindly suggest how to achieve this

Ex :

Input

1,ABCDE

Output:

1,SABCD
1,SSABC
1,SSSAB
1,SSSSA
1,SSSSS

I have a requirement to pass timestamp value which I got it from unix command in sequence job. One of the parallel jobs required parameter to be passed into it. But sequence job got failed because of Invalid param/limit value. Kindly suggest how to handle this scenario and pass date time value. Valu...

Please help me and provide permanent solution to handle this requirement.

Hi All, I have a requirement to copy header count and paste it in its detail records.I need logic to create col4 based on header. I tried splitting header and detail records and did left outer join with detail record link as primary. I did find duplicates and it got cross joined. Note : My file cont...