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: 
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