DSXchange

you can achieve the result via using column import and pivot stage for e.g column1 Column2 12 1,2,3,4,5 13 5,4,3,2,1 Using colum import stage split the comma oriented data in to seperate columns column1 iclmn1 iclmn2 iclmn3 iclmn4 iclmn5 12 1 2 3 4 5 13 5 4 3 2 1 Now use the Pivot State, in the outp...

The simplest wayt to do is send one of the data thru a cpy stage and rename the field for eg. if you are sending the File1 data then File1_<ColumnName> this apply to all the column except the key column and do a join with other file and the key column should be partioned and sorted and select only t...

The merge is only can be used when there is one -to -one relation ship.

as Ray mentioned you may be decalared the coulmn as Decimal instead of Varchar. so please check the scema of your job

as Ray mentioned you may be decalared the coulmn as Decimal instead of decimal. so please check the scema of your job

Trim(Input_Col,'0','L')

You can not convert 00015.50 to 15.50 when you doing decimal to decimal. The Trim function only work when you convert a column from decimal to Varchar then you can achieve the desired format you needed.

Hi Gurus, I am having a problem in spliting a single row of records in to 2 output rows eg: Input: cust id Name Lastname age 1 Prab raj 23 2 sam rob 24 output: Custid Name Lastname Custid age 1 Prab Raj 1 23 2 Sam rob 2 24 Can any one suggest me which stage to choose to do this function

Hi Gurus, I am having a problem in spliting a single row of records in to 2 output rows eg: Input: cust id Name Lastname age 1 Prab raj 23 2 sam rob 24 output: Custid Name Lastname Custid age 1 Prab Raj 1 23 2 Sam rob 2 24 Can any one suggest me which stage to choose to do this function

but there is no collecter in data Stage what stage to choose to merge the files. sequential file can't have multiple inputs

Hi Gurus, I am having a problem in spliting a single row of records in to 2 output rows eg: Input: cust id Name Lastname age 1 Prab raj 23 2 sam rob 24 output: Custid Name Lastname Custid age 1 Prab Raj 1 23 2 Sam rob 2 24 Can any one suggest me which stage to choose to do this function