Hi, I need to sum up the fieldnames in red: Opening Balance and sum, but they are in different tables. How can I do it? Currently the table clbal contains all variables from bal and clbal tables. The words in blue are the common variables.
load*,date(timestamp#(Date, 'YYYYMMDDhhmm')) as DATE;
storelocation AS StoreLocation,
Opening_Balance as openingbal
(txt, codepage is 1252, embedded labels, delimiter is '|', msq);
load *,if(peek(StoreLocation)=StoreLocation,peek(openingbal),0) as Closing_Balance,