Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1 Solution
Accepted Solutions
This is actually pretty easy in Talend -- if you've done it before
To do this kind of pivot, you're going to use two components together: "tDenormalize" and "tExtractDelimitedFields"
the tDenormalize will flatten your original data into two rows -- one for each team. Then we use tExtractDelimitedFields to break the data into the score1..score3 columns.
Please see the screenshots below. Please let us know if you have any more questions, or if this is not clear.
To do this kind of pivot, you're going to use two components together: "tDenormalize" and "tExtractDelimitedFields"
the tDenormalize will flatten your original data into two rows -- one for each team. Then we use tExtractDelimitedFields to break the data into the score1..score3 columns.
Please see the screenshots below. Please let us know if you have any more questions, or if this is not clear.
This is actually pretty easy in Talend -- if you've done it before
To do this kind of pivot, you're going to use two components together: "tDenormalize" and "tExtractDelimitedFields"
the tDenormalize will flatten your original data into two rows -- one for each team. Then we use tExtractDelimitedFields to break the data into the score1..score3 columns.
Please see the screenshots below. Please let us know if you have any more questions, or if this is not clear.
To do this kind of pivot, you're going to use two components together: "tDenormalize" and "tExtractDelimitedFields"
the tDenormalize will flatten your original data into two rows -- one for each team. Then we use tExtractDelimitedFields to break the data into the score1..score3 columns.
Please see the screenshots below. Please let us know if you have any more questions, or if this is not clear.