Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

T Map without join

Hello, I am new to Talend and rewriting some of the Talend code. The issue is there is a tmap that doesn't have a join condition but the ports from two pipelines are dragged to the target. How can this be possible? how can we join two pipelines without a join condition? details are below as i couldn't attach a screenshot. 

 

Source 1: Flat file

columns:  CODE STRING 5

Source 2: Mysql Table A

columns: STATE STRING 2

                REGION STRING 5

 

The Talend tmap is used to join both the pipelines but I don't see both of them connected via a link that usually shows they are joined on that columns. Could you please help me out. TYIA. this would be a big help. 


Regards,

Kiran

Labels (3)
1 Solution

Accepted Solutions
vapukov
Master II
Master II

Hi,

 

without JOIN conditions it will be CROSS JOIN:

0683p000009M4wB.png

https://www.w3resource.com/sql/joins/cross-join.php

 

0683p000009M4wG.png

View solution in original post

2 Replies
vapukov
Master II
Master II

Hi,

 

without JOIN conditions it will be CROSS JOIN:

0683p000009M4wB.png

https://www.w3resource.com/sql/joins/cross-join.php

 

0683p000009M4wG.png

Anonymous
Not applicable
Author

Thank you very much vapukov. Is there a way you can share the screenshot of the tmap? Just wanted to make sure what ever i am looking for is same. 

 

Here is my screenshot. Row1 and Row2 doesn't have a link which clearly says that there is no join condition. can this be considered as cross join? 


thumbnail_IMG_9394.jpg