Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
After checking all unpivot options and components, I went for tUnpivotRow v1.1 from user daztop, which works well for me, many thanks.
Please see a more detailed review by me on the review page on Talend exchange.
I however ran into one issue, that looks like a bug to me: I was able to depivotize string data only. Float or date formated data did not work. I received an error "conversion error string to float" from the component.
Here#s screen shot of the schema configuration of the component and the error message:
As a workaround I convert data to / from strings before / after using the component.
I would be interested to know, if there can be a configuration mistake by me, or if this is a bug, that can be potentially fixed.
I use TOS 5.6.2.
Please see a more detailed review by me on the review page on Talend exchange.
I however ran into one issue, that looks like a bug to me: I was able to depivotize string data only. Float or date formated data did not work. I received an error "conversion error string to float" from the component.
Here#s screen shot of the schema configuration of the component and the error message:
As a workaround I convert data to / from strings before / after using the component.
I would be interested to know, if there can be a configuration mistake by me, or if this is a bug, that can be potentially fixed.
I use TOS 5.6.2.
Sorry, second try here is the screenshot of the tUniPivotRow component configuration, that causes the error:
Explanation
I want to unpivotize consumption data of different materials. Up to the consumption data columns I have got several material master data columns, that represent the pivot key. The column labels to be unpivotized are p1, p2, p3,... - each denoting consumption period of time. Data type of consumption data itself is double. To my understanding the data types of the unpivot results should be the following
- pivot_key: string (this is the field where the p1, p2, p3,... end up - each of them of data type string in the input file as well)
- pivot_value: double (as the consumption data of each period end up there)
And this causes the error shown above.
It works, if I declare pivot_value as string as well. I had the same experience with a date data type as well.
My conclusion is, that this unpivot component seems to convert every input value into a string.
Unless I make a mistake, that I would be happy to learn about - to avoid awkward data conversion before and after this component
Explanation
I want to unpivotize consumption data of different materials. Up to the consumption data columns I have got several material master data columns, that represent the pivot key. The column labels to be unpivotized are p1, p2, p3,... - each denoting consumption period of time. Data type of consumption data itself is double. To my understanding the data types of the unpivot results should be the following
- pivot_key: string (this is the field where the p1, p2, p3,... end up - each of them of data type string in the input file as well)
- pivot_value: double (as the consumption data of each period end up there)
And this causes the error shown above.
It works, if I declare pivot_value as string as well. I had the same experience with a date data type as well.
My conclusion is, that this unpivot component seems to convert every input value into a string.
Unless I make a mistake, that I would be happy to learn about - to avoid awkward data conversion before and after this component