Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
]
Restarted my PC and the inline load now works
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
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;
The problem is now anywhere in my model i have a join i recieve the same error
Restarted my PC and the inline load now works