Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Columns into Rows
- Thread starter sanred
- Start date
This is the reverse process of what can be established using a normalizer.
It involves the following steps:
1. Create expression, create 4 outgoing ports each acting on the input of 'order' like:
IIF(Order = 'P','P',null)
2. Use an aggregator to denormalize the 4 records into one.
Aggregate over AC_key, using a min or max operator on the four ports.
3. Use a second expression transformation to concatenate the 4 ports into one outgoing string.
So, the strategy should be :
expression - aggregator - expression
If you need an example, drop me a mail..........
T. Blom
Information analyst
tbl@shimano-eu.com
It involves the following steps:
1. Create expression, create 4 outgoing ports each acting on the input of 'order' like:
IIF(Order = 'P','P',null)
2. Use an aggregator to denormalize the 4 records into one.
Aggregate over AC_key, using a min or max operator on the four ports.
3. Use a second expression transformation to concatenate the 4 ports into one outgoing string.
So, the strategy should be :
expression - aggregator - expression
If you need an example, drop me a mail..........
T. Blom
Information analyst
tbl@shimano-eu.com
- Thread starter
- #4
Yep,
It is directly proportional with the number of values order can take. So, with something like ordertype you will have a limited set. If you have no idea of the values that you can expect, this will not be a feasable strategy, cause you will not have any idea how many ports to define.
In the past I dabbled with these problems by using VBA instead of Informatica, but that was code I picked up somewhere (not being very able with VBA ..)
T. Blom
Information analyst
tbl@shimano-eu.com
It is directly proportional with the number of values order can take. So, with something like ordertype you will have a limited set. If you have no idea of the values that you can expect, this will not be a feasable strategy, cause you will not have any idea how many ports to define.
In the past I dabbled with these problems by using VBA instead of Informatica, but that was code I picked up somewhere (not being very able with VBA ..)
T. Blom
Information analyst
tbl@shimano-eu.com
sanred,
Possible to share the solution that you used. Is it dynamic or you need to know the exact now of rows for each unique value.
blom,
Many a thanks for your reply. Yeah not feasible if the no. of rows is not known predetermined. But is this VBA is in the Informatica or something external.
Thanks
Sri
Possible to share the solution that you used. Is it dynamic or you need to know the exact now of rows for each unique value.
blom,
Many a thanks for your reply. Yeah not feasible if the no. of rows is not known predetermined. But is this VBA is in the Informatica or something external.
Thanks
Sri
- Status
Similar threads
- Locked
- Question