June 29, 2011 at 3:31 am
suppose my sourse data like id,name,sal
1,vasu,100,200
now i want destination data like id,name,sal
1,vasu,100
1,vasu,200
how to solve this task plese tell me
my mail id asranantha@gmail.com
June 29, 2011 at 3:37 am
you could do this by first using a multi-cast to split and duplicate the rows, then use a derived column transformation to populate a 'measure' colum with the correct measure.
and then a union transformation to put all the data back into one dataflow again.
June 29, 2011 at 3:51 am
If the source data is in SQL, a simple query will do this.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 29, 2011 at 3:55 am
in derived transformation i dont know what is exactly expresion
plese send expresion how to write condition derived tranformation
June 29, 2011 at 4:04 am
its difficult to write you an expression without knowing the column details.
but in general it would be a derrived column called measure and then i would simply add either column 1 or column2 to this, you would have two of these and when you union the data flow back together they should be in the expected format.
or if coming from SQL take Phil's suggestion and write a query.
June 29, 2011 at 4:14 am
My mistake wrong post
__________________________________________________________________________________
Steve J
Jnr Developer
BSc(Hon)
June 29, 2011 at 4:20 am
no some times data came this format id, name ,sal
1,srinu,100,200
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply