Unknown load type error

[vvvvvvizard]

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

]

[ogautier62]

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]

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]

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

[vvvvvvizard · Accepted solution]

Restarted my PC and the inline load now works