Hello, I have a csv import that is not dimensioned by time and date in the same cell. It can not be changed for a monthly process import. I am 90% of the way there. I created an import module (not dimensioned by time) and a reporting module that is dimensioned by time. I am able to pull in the data to the reporting module by manually filling in the import module line item time.
How can I map time to my import module line item? I created a mapping module that should do the trick but can't figure out the formula to do so.