topic Need answer on Inner Join and its working in QlikView

Need answer on Inner Join and its working

anil_y_86 — Mon, 28 Jul 2014 13:55:43 GMT

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

]

;

Mon, 28 Jul 2014 13:57:45 GMT

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 — Mon, 28 Jul 2014 14:10:09 GMT

That makes sense.

Thank you