update segment based on a period

[viveksingh]

Hi Every one,

I have data with Agent, Segment, Period. Now I want to insert another column to table based on a period.

Data is like below:

Expecting like below. It should take Max Year(2018) and March as reference and update segment untill 2018 March. And the reset should not update.

Please advise on this.

[JordyWegman]

Hi Viveksingh,

How is March 2018 determined? Based on the current month of the previous year? Should next month everything be updated until April 2018?

You can create this by doing the following:

Create a mapping table with the new information and use this in combination with an if statement like: If(Period<=$(vCurrentPeriod),Applymap('YourCreatedMappingTable)',Agent & '|' & Segment,0),OldSegment) as New Segment.

Jordy

Climber

[viveksingh]

March is the fixed month and 2018 is max Year from the available data.  Data will come on monthly basis. Once we receive March data we have to take Max Year march as reference and should update segment until March Max Year, also, It should not update from April Max Year to Feb next year.

[viveksingh]

Any inputs on this please

[JordyWegman]

You should consider the approach I explained earlier. This should work. Do you need some help with this code?

Jordy

Climber

[viveksingh]

I’m facing issues in getting Max year and month as March in vCurrentPeriod.
I got the max year in one variable and month number in another variable and I created one more variable combining the max year and march. When I use in if condition, it is not working as expected