topic tDenormalize not denormalizing in Talend Studio

tDenormalize not denormalizing

Anonymous — Fri, 28 Sep 2018 07:48:27 GMT

Hi all, I am trying to use tDenormalize but no success. My Data is as the picture entails.Data

What I want to do is merge the values of texts of same RecordID. I tried using tDenormalize but I keep getting exactly that not denormalized Data.

Any suggestions?

TIA

otaner

Re: tDenormalize not denormalizing

Anonymous — Fri, 28 Sep 2018 19:55:03 GMT

Hi,

Could you please share the component details of tdenormalized component and also the schema details (both input and output)?

Warm Regards,

Nikhil Thampi

Re: tDenormalize not denormalizing

Anonymous — Sat, 29 Sep 2018 02:59:57 GMT

Hi Nikhil

My case is solved now.

The problem was I had an integer field in the mix (Position), which is
actually irrelevant in the end since the records that uses the position
fields will then be removed once they are denormalize.

Nevertheless, if I include the Position in tDenormalization fields it
complains that integer cannot be converted to String. Fair enough, so I did
not include it as part of the denormalization fields. Hence, it always
gives me an incorrect denormalization output.

So I removed it completely from my schema and presto the denormalization
output is perfect.

I was just baffled that I was not allowed to use integer in my
denormalization schema. I guess the function only works with Strings. The
next cases, I just had all my fields in Strings then convert them to other
datatypes before my final output.

otaner