Forum Discussion

uvrao33's avatar
uvrao33
New Contributor III
2 months ago
Solved

Time/data setting in data source/Transformation rule for Multiperiod upload (delimited files)

Hi Everyone, I'm trying to build Data source and transformation rule for multi period manual data load through single file. The import step didn't succussed. Can anyone suggest time settings in d...
Data Integration
Data Sources
Transformation
  • LinaU's avatar
    LinaU
    2 months ago

    Hi uvrao33,

    When you select the Data Source at the top, look at the Properties section on the bottom half of the page, just below the data source image. That’s where you’ll find the Data Structure Type field set to Matrix Data:

     

LinaU's avatar
LinaU
New Contributor II
2 months ago

Hello,

You should set the Data Source Property – Data Structure Type to Matrix Data instead of Tabular Data. Then, create eleven additional Time Source Dimensions, set their Data Type to Matrix DataKey Text, and map them to your columns, like this:

 

uvrao33's avatar
uvrao33
New Contributor III
2 months ago

Hi LinaU,

I don't see Matrix data option for Data Type, I've options Data Key text, Stored Datakey text, Global Datakey time and Current datakey time. Please advise where can I get Matrix data.