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 st...
  • 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.