Combine Records
Posted: Wed Mar 25, 2009 4:51 am
Hello,
i have tried and searched for hours, and i don't find a solution!
I have the following type of data input:
Record-Id, Field-Name, Field-Value
1,Name,Hagedorn
1,Age,50
2,Name,Schmitz
2,City,Hamburg
2,Income,50000
3,Name,Meier
3,City,Berlin
You see, not all columns are always available for each id.
And i want to get the following output:
Record-Id, Name, City, Age, Income
1,Hagedorn,,50,
2,Schmitz,Hamburg,,50000
3,Meier,Berlin,,
All Input Records with the same ID should be in one Output record, and the values should be assigned to the Outputfields accordingly to the Fieldnames.
The real file has more than 300 possible Fieldnames!
The Combine Records Stage seems not to solve my problem.
Is it in general possible with Datastage?
i have tried and searched for hours, and i don't find a solution!
I have the following type of data input:
Record-Id, Field-Name, Field-Value
1,Name,Hagedorn
1,Age,50
2,Name,Schmitz
2,City,Hamburg
2,Income,50000
3,Name,Meier
3,City,Berlin
You see, not all columns are always available for each id.
And i want to get the following output:
Record-Id, Name, City, Age, Income
1,Hagedorn,,50,
2,Schmitz,Hamburg,,50000
3,Meier,Berlin,,
All Input Records with the same ID should be in one Output record, and the values should be assigned to the Outputfields accordingly to the Fieldnames.
The real file has more than 300 possible Fieldnames!
The Combine Records Stage seems not to solve my problem.
Is it in general possible with Datastage?