topic Fetching Same Field from Same Names in QlikView

Fetching Same Field from Same Names

Tue, 30 Nov 2010 08:32:40 GMT

My Code is:

Load *;

sql select VAPMA~KUNNR VBPA~KUNNR

FROM VAPMA INNER JOIN ON (VAPMA~VBELN = VBPA~VBELN) ;

-----------------------------------------------------------------------------------------------------------------------------------

ERROR : KUNNR is already declared.

while I am fetching data from sap. I require both KUNNR fields .

llauses243 — Tue, 30 Nov 2010 08:53:50 GMT

Hi, good luck, Luis

Tue, 30 Nov 2010 09:44:01 GMT

Same error continue after putting comma.

suniljain — Tue, 30 Nov 2010 10:02:03 GMT

one solution is you have to seperately load VBPMA and VBPA and then join it in qlikview script.