Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to use intevalmatch function, but using the help I couldn't.
ScaleBudget:
LOAD * Inline
[
From,To,CodBudget
0,3499,1
3500,6999,2
7000,10499,3
10500,15999,4
16000,19999,5
20000,1000000000,6
];
Budget:
LOAD
Budget
FROM
$(Path_QVD)Budget.QVD (qvd);
IntervalMatch1:
IntervalMatch(Budget)
LOAD
From,
To
Resident ScaleBudget;
As I understood I could do a left join to get a table with the Budget and the CodBudget inline ...
Thanks in advance.,
Hi,
Try this,
ScaleBudget:
LOAD * Inline
[
From,To,CodBudget
0,3499,1
3500,6999,2
7000,10499,3
10500,15999,4
16000,19999,5
20000,1000000000,6
];
Budget:
LOAD
Budget
FROM
$(Path_QVD)Budget.QVD (qvd);
IntervalMatch1:
Left Join(Budget)
IntervalMatch(Budget)
LOAD
From,
To
Resident ScaleBudget;
Hope it helps,
no, it doesn't work
Hi,
Check this code. Note that QlikView is case sensitive, and note the names of the tables in the example.
Hope that helps.
Miguel
ScaleBudget_Temp:
LOAD * Inline
[
From,To,CodBudget
0,3499,1
3500,6999,2
7000,10499,3
10500,15999,4
16000,19999,5
20000,1000000000,6
];
ScaleBudget:
LOAD
From as Min,
To as Max
resident ScaleBudget_Temp;
Budget:
LOAD
Budget
FROM
$(Path_QVD)Budget.QVD (qvd);
IntervalMatch1:
IntervalMatch(Budget)
LOAD
Min,
Max
Resident ScaleBudget;
Left Join(ScaleBudget)
LOAD
From as Min,
To as Max,
CodBudget
Resident ScaleBudget_Temp;
Drop Table ScaleBudget_Temp;
Rename Field Min as From;
Rename Field Max as To;
Or you could drop fields min and max if you don´t need.
Drop Fields Min,Max from ScaleBudget;