Changing Dimension

[raadwiptec]

I have 2 Sources.. 

Source 1

-----------------------

1. Payment Dates 2. Amount 3.Player, 4.Currency , Year

We make a key based on Player ,currency and Year

Source 2

-------------------------

Player	Currency	End Year	Agent	Effective Date	Deletion Date
2861	AUD	2016	9987	20190926	20210117
2861	AUD	2016	9234	20210118	20210223
2861	AUD	2016	9766	20210224	99999999

The Objective is to bring the Agent Field out based on the Payment Dates.. 

So for Ex: If payment Date is 20200926 - The Agent should be 9987

                    If payment Date is 20210201 - The Agent should be 9234

                else      If payment Date is 20210922- The Agent should be 9234

Thanks to suggest

[Vikash · Accepted solution]

Hi,

You can use -

Source1:
LOAD * INLINE [
Payment Dates, Amount, Player, Currency, Year
20200926, 2500, 2861, AUD, 2016
20210201, 3500, 2861, AUD, 2016
20210922, 6512, 2861, AUD, 2016
];

Source2:
LOAD * INLINE [
Player, Currency, End Year, Agent, Effective Date, Deletion Date
2861, AUD, 2016, 9987, 20190926, 20210117
2861, AUD, 2016, 9234, 20210118, 20210223
2861, AUD, 2016, 9766, 20210224, 99999999
];

Inner join IntervalMatch([Payment Dates])
Load [Effective Date],
[Deletion Date]
resident Source2;

 Hope this helps!

VK