Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
yoxler
Contributor III
Contributor III

tMap as lookup in tMap

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

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

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.

View solution in original post

6 Replies
Aukema
Creator
Creator

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

TRF
Champion II
Champion II

Usual usecase.
No problem to have a tMap as a lookup for another tMap.
yoxler
Contributor III
Contributor III
Author

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
TRF
Champion II
Champion II

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.
yoxler
Contributor III
Contributor III
Author

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!

TRF
Champion II
Champion II

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