topic Re: How can we lookup row value with Column attributes names in Talend Studio

How can we lookup row value with Column attributes names

Anonymous — Sat, 16 Nov 2024 09:02:51 GMT

Hi All,

we are receiving data from the different source systems, one table having KPI data another one having KPI data along with attributes name as column data. please advise how can I lookup rows data with column attributes name in the 2nd table.my target is HDFS

I have uploaded sample data format of my input and output, please have a look and assist how to archive this requirement ??

Regards,

Avinash

Re: How can we lookup row value with Column attributes names

Anonymous — Mon, 20 Nov 2017 11:29:59 GMT

Assuming your input columns are not gonna change dynamically, Something like this can be done,

Since there is no joining column in your input files, there is no join in the tmap expression.

However we can use a ternary operator in the expression to get the desired result,

Hope this helps.

Re: How can we lookup row value with Column attributes names

Anonymous — Wed, 29 Nov 2017 04:47:12 GMT

Thanks for your suggestion, I able manage to process the data using tUnpviotRow.

Regards,

Avinash