I would like to ask if it is possible to use ApplyMap function within a selected range of date only because I have a field called Item type, this item type is like a tag if a garment is on a regular price or on Markdown.
Jan 2019 item 1 is tagged as REG
Nov 2019 item 1 is tagged as MD
understanding ApplyMap function, on Nov 2019 item 1 is already MD so previous months (Jan - Oct) it will be also tagged as MD. I want to freeze those previous data before MD.
You can create the Mapping field as composite key, that would have the date (Or the month, which ever is the case) and the Item Code. Like in your example the mapping table data should look like below.
Jan 2019-1, REG
Nov 2019-1, MD
So that you get correct mapping for correct date.
Regards, Kaushik If reply is satisfactory, please "Like" the post. If reply is solution, please mark as "Correct".