Lookup functionality in HDFS target

[varadharaj]

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)

[Madhavi_Konda · Accepted solution]

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

[Madhavi_Konda · Accepted solution]

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