Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvizard
Partner - Specialist
Partner - Specialist

Unknown load type error

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

]

1 Solution

Accepted Solutions
vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

Restarted my PC and the inline load now works

View solution in original post

4 Replies
ogautier62
Specialist II
Specialist II

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

vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

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;

vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

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

vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

Restarted my PC and the inline load now works