Forum Discussion

A_sh's avatar
A_sh
New Contributor
2 years ago

How to Load a Data File having multiple columns of data

I'm trying to load a file that has data in multiple columns like below.

I have created the data source with a Data Type as Matrix DataKey and created source Time Dimensions for 12 months as stated in the screenshot. But when I try to load the data, I get the below error every time. I have already created transformation rules for Scenario and time as below and not sure what else I'm missing here. Can someone please help with this one?

Error Message:

 

Thanks...!!!

Data Integration
Data Management
Import
Transformation
  • JackLacava's avatar
    JackLacava
    2 years ago

    That doesn't look like the configuration is correct. Should look something like this:

    datasource properties:

    As many Time sources as you have periods:

    Note the last property, it's important - it will tell Onestream where to look for the actual period name. That name will have to be mapped in Transformation rules.

     

  • AK's avatar
    AK
    New Contributor III
    2 years ago

    Please check the following in your application:
    Set the appropriate Data Type for Scenario in Data Source
    Proper column number is set for all the Source Time Dimensions
    Matrix DataKey Text is set as the Data Type for all the Source Time Dimensions
    Mappings are proper for Time and Scenario in the Transformation Rule.

    Hope this helps.
    Thanks,
    AK

  • A_sh's avatar
    A_sh
    New Contributor
    2 years ago

    Hi AK,

    Thanks for responding. 

    I checked the below things and everything seems fine to me. 

    Set the appropriate Data Type for Scenario in Data Source - I have setup the Data Type as Datakey Text and provided the Static value.
    Proper column number is set for all the Source Time Dimensions - This seems correct.
    Matrix DataKey Text is set as the Data Type for all the Source Time Dimensions - This seems correct.
    Mappings are proper for Time and Scenario in the Transformation Rule - Mappings are set to One-to-One as stated in my screenshot earlier.

     

    Please let me know if anything else needs to be checked.

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      2 years ago

      From OnePlace, have a look at the log, it will tell you why rows are getting dropped. You'll have to open the generated xfl file in Notepad.

       

      • A_sh's avatar
        A_sh
        New Contributor
        2 years ago

        Hi JackLacava,

        I see the below error in the log. I'm not sure if I've to create any additional mapping rules for time apart from the one I stated in my original post. Please let me know.