Extended interval match help

[#1]

I need help below:

Purchase:

Load * Inline

[

  Supplier, Purchase

  ABC, 125

  DEF, 115

];

Discount:

Load * Inline

[

  Supplier, From, To, Discount

  ABC, 100, 119, 2%

  ABC, 120, 129, 3%

  ABC, 130, 150, 4%

  DEF, 110, 119, 4%

  DEF, 120, 129, 6%

  DEF, 130, 150, 8%

];

Code here will be :

INNER JOIN (Purchase)

IntervalMatch (Purchase,Supplier) Load From, To, Supplier Resident Discount;

Join (Purchase) Load * Resident Discount;

Drop Table Discount;

Drop Fields From,To;

To explain my scenario, I am modifying above example.

I want the discount to be displayed with respect to each supplier.

Supplier1 | Discount1| Supplier2|Disocunt2|......................

Purchase:

Load * Inline

[

  Supplier1,Supplier2, Supplier3,Purchase

  ABC, XYZ,EWQ,125

  DEF,FRT, YUT,115

];

Discount:

Load * Inline

[

  Supplier, From, To, Discount

  ABC, 100, 119, 2%

  ABC, 120, 129, 3%

  ABC, 130, 150, 4%

  DEF, 110, 119, 4%

  DEF, 120, 129, 6%

  DEF, 130, 150, 8%

  XYZ, 110,130,5%

  XYZ, 110,130,5%

  XYZ, 100,120,5%

  FRT,110,140, 2%

  FRT,110,112, 2%

  EWQ,110,140, 2%

  EWQ,110,140, 2%

EWQ,110,140, 2%

YUT,105,118,6%

];

Wondering how to depict this in current code?

[anbu1984]

Check this qvw

[jagan]

Hi,

Try this script

Temp:

Load * Inline

[

  Supplier1,Supplier2, Supplier3,Purchase

  ABC, XYZ,EWQ,125

  DEF,FRT, YUT,115

];

Purchase:

LOAD

Supplier1 AS Supplier,

Purchase

RESIDENT Temp;

Concatenate(Purchase)

LOAD

Supplier2 AS Supplier,

Purchase

RESIDENT Temp;

Concatenate(Purchase)

LOAD

Supplier3 AS Supplier,

Purchase

RESIDENT Temp;

DROP TABLE Temp;

Discount:

Load * Inline

[

  Supplier, From, To, Discount

  ABC, 100, 119, 2%

  ABC, 120, 129, 3%

  ABC, 130, 150, 4%

  DEF, 110, 119, 4%

  DEF, 120, 129, 6%

  DEF, 130, 150, 8%

  XYZ, 110,130,5%

  XYZ, 110,130,5%

  XYZ, 100,120,5%

  FRT,110,140, 2%

  FRT,110,112, 2%

  EWQ,110,140, 2%

  EWQ,110,140, 2%

EWQ,110,140, 2%

YUT,105,118,6%

];

INNER JOIN (Purchase)

IntervalMatch (Purchase, Supplier) Load From, To, Supplier Resident Discount;

LEFT Join (Purchase) Load * Resident Discount;

Data:

NoConcatenate

LOAD

DISTINCT *

Resident Purchase;

DROP TABLE Purchase;

Drop Table Discount;

Drop Fields From,To;

Regards,

Jagan.