Forum Discussion

uvrao33's avatar
uvrao33
New Contributor III
2 days 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
    6 hours 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
19 hours 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: