How to do Excel Search in Anaplan
Has anyone built an Excel Search function equivalent in Anaplan? What I would like to replicate is:
1. Client has a text mapping table (screenshot 1) which maps Strings in Column B to their expense classification (Column C & D)
2. SAP extraction which contains a column called Text (screenshot 2) , Column H.
3. Then client planner will search the Text in screenshot 1 Column B in SAP extraction Column H. If any match is found, expense classifications will be mapped following the mapping table. Otherwise they all classified as "Others"
Any idea is welcome to share. Thanks!