Interval match

[Carlaf_93]

Good morning,

i'm using this code to categorize the customer's sales into range of values.

I would like to create a store of this table.

How can i do it?

[BASE2021A]:                                         --> sales
LOAD
COD_Customer,
COD_Ag,
VAL_VEN1
FROM [lib:/BASE2021A.QVD]
(qvd);

[pip]:                                                             --> range
LOAD
range,
LIM_MIN ,
LIM_MAX ,
AutoNumberHash128(LIM_MIN,LIM_MAX) AS CLASSID
FROM [lib:///TABELLARANGE2.QVD](qvd);

[LINKFASCE]:                                           --> union interval match
IntervalMatch(VAL_VEN1)
Load LIM_MIN,LIM_MAX
Resident pip;
Left Join (BASE2021A)
Load (VAL_VEN1),
DUAL (LIM_MIN&'-'&LIM_MAX,LIM_MIN) AS RANGEACQUISTI,
AutoNumberHash128(LIM_MIN,LIM_MAX) AS CLASSID
Resident LINKFASCE;
drop table LINKFASCE;

[rubenmarin · Accepted solution]

Hi, if you are doing joins to the BASE2021A table, you only need to do the store of that table to have all data.

STORE BASE2021A into [$(vPathToQvd)BASE2021A.qvd] (qvd);