topic Re: Lookup functionality in HDFS target in Qlik Compose

Lookup functionality in HDFS target

varadharaj — Thu, 20 Mar 2025 15:56:15 GMT

I have 2 tables

Table A

ID Name Dept Id

1 ABC 10

Table B

Dept Id Dept Name

10 IT

So i need to add the column dept name in Table A as

ID, NAME,DEPT ID,DEPT NAME

Please suggest any possible ways to do it .

using compose version -->V6.5.0.179 with spark project (HDFS)

Re: Lookup functionality in HDFS target

Madhavi_Konda — Mon, 01 Jun 2020 20:43:17 GMT

Hi Varadhraj,

On your metadata screen for table A, add the column dept_name as new attribute and choose the datatype and click validate.
On data storage tasks, please double click on a mapping. You will see lookup icon on dept_name column.
Please open and then enter condition like ${Lookup.dept_id}=${Landing.dept_id} and result column as
${Lookup.dept_name} and click ok. Validate the changes. Drop and recreate the necessary tables if necessary.

Please raise a support case if it is not clear. We can walk through the steps.

Thanks,

Madhavi

Re: Lookup functionality in HDFS target

Madhavi_Konda — Mon, 01 Jun 2020 21:31:09 GMT

Please open a support case at https://attunitysupport.qlik.com/login?ec=302&startURL=%2Fs%2F