topic Re: tMap as lookup in tMap in Talend Studio

tMap as lookup in tMap

yoxler — Tue, 23 Oct 2018 10:11:53 GMT

Hi,

I'm processing a messy file and I need to split columns in severals steps and in a step I want an output from tMap as a lookup in an another tMap.

Do I need to put the output of the tMap in a file and then use it as lookup in the other tMap or is there any other way because I have no need to have it in a file.

Any help appreciated.

/Andreas

Re: tMap as lookup in tMap

Aukema — Tue, 23 Oct 2018 10:24:06 GMT

Some screenshots could help, but it should be possible to have a tMap as lookup input. What's the issue you are experiencing?

Re: tMap as lookup in tMap

TRF — Tue, 23 Oct 2018 11:01:38 GMT

Usual usecase.
No problem to have a tMap as a lookup for another tMap.

Re: tMap as lookup in tMap

yoxler — Tue, 23 Oct 2018 12:36:54 GMT

Attached file.

I'm trying connect custWithT1 to newId but Studio wont have it.

The crossed over circle is also there, however not visible when doing the screen shot. Just as you get when the components are not compatible.

talend studio tmap.png

Re: tMap as lookup in tMap

TRF — Tue, 23 Oct 2018 13:09:03 GMT

The job capture is partial but it seems you want join 2 flows issued from a previous tMap. This is not possible to do that in the subjob where they have been separated. You need to store intermediate result in a tHashOutput or a file, then reuse them in the next subjob.

Re: tMap as lookup in tMap

yoxler — Tue, 23 Oct 2018 13:33:54 GMT

Yeah I wanted to join the two flows without having to create a file.

I wanted to skip the create file part. I will try the tHashOutput, thanks!

Re: tMap as lookup in tMap

TRF — Tue, 23 Oct 2018 14:01:24 GMT

Thank's to mark your case as solved as soon as you finish your test.