topic Unknown load type error in QlikView

Unknown load type error

vvvvvvizard — Wed, 22 Aug 2018 07:06:39 GMT

Commission_Cash:

LOAD [Month Sql] as Invoice_Detail.Invoice_Date_YYYYMM,

[Rep Cash Comm %] as Sundry_Commission

//[Rep Ipr Comm %],

//[Rep Rehire Comm %]

FROM

$(vPath)Sundry Items Comm Table.xlsx]

(ooxml, embedded labels, table is List_Frame_1);

Join

LOAD Type Inline [

Type

Cash

];

if i comment out the Join word both tables load , if i add the join word back i get the unknown the error below

Unknown LOAD statment error

Join

LOAD Type Inline [

Type

Cash

]

Re: Unknown load type error

ogautier62 — Wed, 22 Aug 2018 07:19:26 GMT

Hi,

what do you expect as result ?

if you want to add two columns type and cash at you table commission

maybe use concat instead of join

regards

Re: Unknown load type error

vvvvvvizard — Wed, 22 Aug 2018 09:38:53 GMT

Even this code doesnt run on my pc but runs on a friends PC

ABC:

LOAD * Inline [

A , B

B , 10

C , 20

D, 30

];

JOIN

LOAD Type Inline [

Type

Cash

];

Exit script;

Re: Unknown load type error

vvvvvvizard — Wed, 22 Aug 2018 09:40:02 GMT

The problem is now anywhere in my model i have a join i recieve the same error

Re: Unknown load type error

vvvvvvizard — Wed, 22 Aug 2018 10:22:01 GMT

Restarted my PC and the inline load now works