I'm trying out talend and made a basic excel to import and then spit out in excel unpivoted. I downloaded and installed tUnpivot, but that's not what's failing me, I think.
I edited the Excel schema and made this:
But then when I clicked the output tab, this happened.
Which is unfortunate because my tUnpivotRow complains
Because it has no columns to pivot. So I look at the available columns by clicking the row1 connector, and it's only pivot key
And I really want it to be the Source, Segment and Company from above. So do I just force the issue in the connector and hand insert the columns. I just started Talend, so haven't really delved into the generated code, nor read up on the objects it makes available. I think it would probably take a week to figure it out, and I really don't have a week to mess around. I did take a peek at the code, and noticed the code itself is throwing up an error, probably because row2.pivot_key doesn't exist if the row 2 connector doesn't really carry a state and just reflects the data going between the components. It seems that is the case based on how the code is generated. There is no connector code. It's just component to component. So I could monkey around with the code, but is that the real solution? I'm probably going to have to monkey with the code anyway because the excel thingy steps on my headers by adding a "_" in place of the first character of my header instead of appending it to the beginning. Had it done the latter, I could just manipulate the value in the columns easier after I unpivot, because I'd know just to break off the "_" and parse the number.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema