Forum Discussion

THENDRICKSON's avatar
THENDRICKSON
Contributor
3 months ago

Data is not getting imported into the correct quarter

I'm having trouble getting my data files to import into the correct quarter of the workflow. Whenever I load the data into the Q2 import of the workflow, it removes the Q1 data and adds the Q2 data t...
Import
Workflow
  • THENDRICKSON's avatar
    THENDRICKSON
    3 months ago

    I figured out what my issue was. Under Application Properties, I had the "Enforce Global POV" set to True and the Global POV was set at Q1 of 2024. Once I changed that setting to False, my data started loading into the correct quarters. 

    Thank you for your help! 

JoakimK's avatar
JoakimK
Contributor
3 months ago

So there are a couple things to look out for here, among those what has been mentioned already. However, some additional points perhaps?

1. Are you perhaps importing an Excel file with a defined named range, as this will use its own settings for most of the settings in the datasource instead of the selected ones.

2. DO you have transformation rules for Time that are possible not set correct? (using the "Current DataKey Time" might not require these, but if they are there they will be adhered to)