Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
anil_y_86
Contributor III
Contributor III

Need answer on Inner Join and its working

I have loaded the below script and I received the weird output (I have attached the output file as image with this discussion).

Now my question is why the table box is displaying //A even after commenting the fields A,C in Table2 ?

Table1:

Load * inline

[

A,B

1,aa

2,bb

3,cc

4,dd

]

;

Inner Join(Table1)

Table2:

Load * inline

[

//A,C

//1,xx

//2,yy

//5,tt

]

;

2 Replies
Not applicable

that's an inline table, so it is treating the // as part of the data, you need to remove the row totally

Joe

anil_y_86
Contributor III
Contributor III
Author

That makes sense.

Thank you