Four Stars

Talend overwrites my headers

Using the excel importing thingy, I have a table like this:

 

image.png

I want to import like this, using the first row as my headers

image.png

But then talend rewrites the columns thusly, which is annoying.  These columns are weeks.  I'd like to keep them so I can unpivot the columns

image.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

Re: Talend overwrites my headers

Hello,

Can we consider this topic as resolved?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
2 REPLIES
Four Stars

Re: Talend overwrites my headers

https://community.talend.com/t5/Design-and-Development/the-names-of-the-colunms-are-numbers/td-p/215...

Found it. Bother...
I can't believe I'm writing it, but maybe power query is not so bad...
Moderator

Re: Talend overwrites my headers

Hello,

Can we consider this topic as resolved?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.