tDenormalize not denormalizing

[Anonymous]

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

[Anonymous]

Hi,

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

Warm Regards,

Nikhil Thampi

[Anonymous · Accepted solution]

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