Page Comparison

// Get datamart context
def dmContext = api.getDatamartContext()

// Create datamart query1
def dmQueryItem = dmContext.newQuery(dmContext.getDatamart("Transactions"), false)
dmQueryItem.
select("INVOICE_NUMBER").
select("ACCOUNT_NAME").
select("LOWIEA").
select("QUANTITY_BUOM").
select("FINAL_GIVEN_NET_PRICE").
select("FINAL_GIVEN_NET_PRICE_UNIT").
where(Filter.equal("INVOICE_DATEYear","2018"),
Filter.equal("SOLD_TO", "12345678"),
Filter.equal("SALES_ORGANIZATION","12345"),
Filter.equal("MATERIAL", "XYZ"))

// Create datamart query2
def dmQueryInvoice = dmContext.newQuery(dmContext.getDatamart("Transactions"), false)
dmQueryInvoice.
select("INVOICE_NUMBER").
select("ACCOUNT_NAME").
select("LOWIEA").
select("QUANTITY_BUOM").
select("FINAL_GIVEN_NET_PRICE").
where(Filter.equal("INVOICE_DATEYear","2018"),
Filter.equal("SOLD_TO", "12345678"),
Filter.equal("SALES_ORGANIZATION","12345"))

def joinFields = [:]
joinFields.put ("INVOICE_NUMBER", "INVOICE_NUMBER")        //Join on Invoice#
joinFields.put ("ACCOUNT_NAME", "ACCOUNT_NAME")            //Join on Account Name
def dmQuery1 = dmContext.newQuery(dmQueryItem, dmQueryInvoice, joinFields, false)
dmQuery1.
select("QUANTITY_BUOM_1", "Quantity").                           //Quantity from dmQueryItem
select("FINAL_GIVEN_NET_PRICE_UNIT_1", "Price").       //Price from dmQueryItem
select("FINAL_GIVEN_NET_PRICE_2" , "Order Value").     //Order Value from dmQueryInvoice
select("ACCOUNT_NAME_1" , "Customer").                        //Customer from dmQueryItem
select("LOWIEA", "Customer Type")                                     //Customer Type from dmQueryItem


// Run query and save result to memory
def result = dmContext.executeQuery(dmQuery1)
if (result) {
def tableContext = api.getTableContext()
tableContext.createTable("Transaction_Current", result)
}


if (api.isInputGenerationExecution()) return

def tableContext = api.getTableContext()
def query = tableContext.newQuery("Transaction_Current")
query.
select("Quantity").
select("Price").
select("Order Value").
select("Customer").
select("Customer Type")

def result1 = tableContext.executeQuery(query)
result1?.getColumnValues(0)