topic Re: Tmap lookup scenario in Talend Studio

Tmap lookup scenario

Prasanna3 — Sat, 18 May 2019 14:56:23 GMT

I have data like below i want to compare primary and secondary in lookup table template id,if both primary and secondary matches with template need to combine element a+b or if only primary matches need to get only a or secondary only matches need to get only b. can some one please help me on this?

Main Flow:

Primary Secondary

1 2

3 4

Lookup:

template element

1 a

2 b

Output:
Element

a+b

Re: Tmap lookup scenario

manodwhb — Sun, 19 May 2019 09:25:26 GMT

@prasan ,find the attached job for your case.

test_job.zip

Re: Tmap lookup scenario

Prasanna3 — Sun, 19 May 2019 12:51:44 GMT

Hi

Not able to import the job

Will that job work if i have data like below and i want output also like
below.

Main Flow:

Primary Secondary

1 2

3 4

Lookup:

template element

1 a

2 b

1 c

Output:
Element

a+b+c

Thanks,

prasan

Re: Tmap lookup scenario

Anonymous — Sun, 19 May 2019 22:24:22 GMT

If you download v7.1 you should be able to see how this job works and recreate it in any version you are running.

Re: Tmap lookup scenario

Prasanna3 — Mon, 20 May 2019 04:39:44 GMT

Hi

Thanks for the solution.

Will that job work if i have data like below and i want output also like
below.

Main Flow:

Primary Secondary

1 2

3 4

Lookup:

template element

1 a

2 b

1 c

Output:
Element

a+b+c

Thanks,

prasan

Re: Tmap lookup scenario

Anonymous — Mon, 20 May 2019 10:05:59 GMT

@prasan I suspect @manodwhb believes that it does work for your problem. Try downloading the new Studio and running the job that Manodwhb supplied. If it works, please assign the solution to Manodwhb 🙂