what I need to obtain is this, and absolutely in the load script:
CDARMM YEAR CAMOMM Gian. IN going OUT going 3722/800 2016 10 + 100 0 3722/800 2016 20 - 0 -5 1257 2016 20 - 0 -34 1257 2016 10 + 70 0
You probably will note that it's a little different from my preceding request (apologize), but I have already many other tables with data that come from a old program for years from 2008 to 2015 and such table are already part of a set analysis. If I obtain 2016 data with the same format of 2015 I save all the time invested in the set analysis structure.
Hope now it's a little bit more clear.
May be like this?
Date(Date#(DTOPMM, 'YYYYMMDD'), 'YYYYMMDD') as DTOPMM,
(html, codepage is 1252, embedded labels, table is @2)
Where not Match(CAMOMM, 70, 71);
(html, codepage is 1252, embedded labels, table is @1);
Year(DTOPMM) as YEAR,
If(Gian. = '+', QTMOMM, 0) as [IN going],
If(Gian. = '-', -QTMOMM, 0) as [OUT going]
DROP Table Warehouse;
245330.qvw 153.8 K
Hopefully I have understood your requirement.
Is this what your looking for?
See second table below to exclude 70 & 71
Test app attached.
Hope this helps!
2Tables_exclude.qvw 153.0 K