Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Order:
LOAD "Document Type" as Order_Type,
"Document No_"&"Line No_" as Order_Entry_Nr,
"No_" as Order_Item_Nr,
'Inkoop' as Order,
"Outstanding Quantity" as Order_Outstanding,
1 as Order_Counter,
"Order Date" as Order_Date
;
SQL SELECT
"Document Type",
"Document No_",
"Line No_",
"No_",
"Outstanding Quantity" ,
"Order Date"
FROM $(DB_CONSTRING)Purchase line"
;
Concatenate
LOAD "Document Type" as Order_Type,
"Document No_"&"Line No_" as Order_Entry_Nr,
"No_" as Order_Item_Nr,
'Sales' as Order,
"Outstanding Quantity" as Order_Outstanding,
1 as Order_Counter,
"Order Date" as Order_Date
;
SQL SELECT
"Document Type",
"Document No_",
"Line No_",
"No_",
"Outstanding Quantity" ,
"Order Date"
FROM $(DB_CONSTRING)Sales Line"
;
This seems to work. I removed " from Purchase line" and Sales Line"
Order:
LOAD "Document Type" as Order_Type,
"Document No_"&"Line No_" as Order_Entry_Nr,
"No_" as Order_Item_Nr,
'Inkoop' as Order,
"Outstanding Quantity" as Order_Outstanding,
1 as Order_Counter,
"Order Date" as Order_Date
;
SQL SELECT
"Document Type",
"Document No_",
"Line No_",
"No_",
"Outstanding Quantity" ,
"Order Date"
FROM $(DB_CONSTRING)Purchase line
;
Concatenate
LOAD "Document Type" as Order_Type,
"Document No_"&"Line No_" as Order_Entry_Nr,
"No_" as Order_Item_Nr,
'Sales' as Order,
"Outstanding Quantity" as Order_Outstanding,
1 as Order_Counter,
"Order Date" as Order_Date
;
SQL SELECT
"Document Type",
"Document No_",
"Line No_",
"No_",
"Outstanding Quantity" ,
"Order Date"
FROM $(DB_CONSTRING)Sales Line
;
Solved by using SQL SELECT *
Solved by using SQL SELECT *