Iam getting 2 tables (Both have same field) when enable the LOAD box at the time of load the table.

[Kohli]

I am connected to My sql database.  And at the time of select the table , I am enable LOAD check box.  then i am getting two table and both tables have same filed. 

EX: 

LOAD  canId,
paperId,
Qno,
answer,
BatchId,
Marks,
complexity,
section

[ExamAnswerSheet]:
 

SELECT  canId,
paperId,
Qno,
answer,
BatchId,
Marks,
complexity,
`section`
FROM EnggQBank.ExamAnswerSheet;

How can i manage this ..

[OmarBenSalem]

It's the same table with 2 part:

1) the SELECT part 

2) The LOAD part

With this, Qlik give u the possibility to :

1) use the language of ur database (MySql) to do transformations, joins etc within the SELECT part.

So, if u're familiar with mySql, and want to use only MySql code, u can only keep the SELECT part; it won't change a thing.

2) But Qlik also gives u to possibility to use Qlik's functions within the LOAD statement.

Here's some example:

a) Only using the Select :

SELECT  canId,
paperId as PAPER,
Qno,
answer,
BatchId,
Marks,
complexity,
`section`
FROM EnggQBank.ExamAnswerSheet;

b) Using Both:

LOAD  canId,
PAPER, //remark now, that u've renamed the PaperID in the select part as PAPER, in the load part, u'll to call the new Name which is PAPER
Qno,
UPPER(answer) as Answer, //u can use Qlik's functions
BatchId,
Marks,
complexity,
section

SELECT  canId,
paperId as PAPER,
Qno,
answer,
BatchId,
Marks,
complexity,
`section`
FROM EnggQBank.ExamAnswerSheet;

In this case, the resulting table will be :

PAPER, 
Qno,
 Answer, 
BatchId,
Marks,
complexity,
section

and please, see this: the preceeding load

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/pr...