Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm struggling to concatenate tables in my script and would appreciate your help.
I would like to concatenate my value entries table with my item ledger entries table inorder to form a single table called ValueEntriesVsItemLedgerEntries
My script looks as follows:
//*******************************VALUE ENTRIES**************************************
ValueEntries:
Load
"Document No_" as "Shipment No",
"Document No_" as "Invoice/Credit note No",
"Item No_" as "Item No",
"Sales Amount (Actual)" as "Value Entries Sales Amount",
"Cost Amount (Actual)" AS "Value Entries Cost Amount";
SQL SELECT
"Document No_",
"Item No_",
"Item Ledger Entry Type",
"Item Ledger Entry Quantity",
"Sales Amount (Actual)",
"Cost Amount (Actual)"
FROM "DynamicsNAV90_Prod".dbo."Ambassador Foods (Pty) Ltd$Value Entry";
//*****************************ITEM LEDGER ENTRIES**********************************************
ItemLedgerEntries:
LOAD
"Document No_" as "Shipment No",
// Year("Posting Date") as "Year Sold",
// Month("Posting Date") as "Month Sold",
Pick (WildMatch("Entry Type", 0,1,2,3,4,5,6), 'Purchase','Sales','Positive Adjm.','Negative Adjm.','Transfer','Consumption','Output') as "Item Ledger Entry Type",
Quantity as "Tonnage Sold";
SQL SELECT
"Document No_",
"Posting Date",
"Entry Type",
Quantity
FROM "DynamicsNAV90_Prod".dbo."Ambassador Foods (Pty) Ltd$Item Ledger Entry";
Where "Entry Type" = '1'
How do I concatenate these 2 tables?
Thank you very much..