Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
You should consider the approach I explained earlier. This should work. Do you need some help with this code?
Jordy
Climber