Tmap lookup scenario

[Prasanna3]

Hi

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

[manodwhb]

@prasan ,find the attached job for your case.

test_job.zip

[Prasanna3]

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

[Anonymous]

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

[Prasanna3]

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

[Anonymous]

@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 🙂