Why isn't Anaplan populating the data?
I am importing a file but Anaplan isnt populating the "Time Stamp" line item. Anaplan is mapping correctly and the import has no errors.
What am I missing?
Best Answer
-
@empressjewel Pardon I wasn't clear. I meant add a filter to the view. So follow instructions below:
- In your module, click on the filter funnel (top middle highlighted in yellow). The Filter pop up window should then display,
- Click on the + sign (highlighted right side in yellow) in the Tab for "OppProductID"
- Add condition for Time Stamp" with condition "IS NOT Blank"
Then check if it returns anything
0
Answers
-
@empressjewel - have you tried the "Custom Mapping" in the import dialogue? This allows you to define the pattern of the date fields and you will be able to affirm the mapping is working when you see the date successfully display in green text (successful translation between the file into Anaplan date format).
0 -
@Tiffany.Rice I just tried custom mapping and it didn't work. It mapped with no errors but the data still did not populate. See attached.
0 -
Color me stumped. The only other points I would say to consider -
- Do you have any security restrictions (selective access or Dynamic Cell Access driver)? Doesn't look like it but always a good thing to check.
- Double check the file you are loading. .csv files can be temperamental, if you open the file and save it can change formatting.
0 -
@empressjewel can you try applying a filter on DAT05 Salesforece Bookings against "Time Stamp" with condition "IS NOT Blank" and see if it returns anything.
0 -
@TristanS I didn't return anything
0 -
@TristanS it worked! Thank you
0