Forum Discussion

ssmith-nova's avatar
ssmith-nova
Contributor
12 months ago
Solved

Matrix Data Load Basics

I have a matrix data load question.  I get the concept of how the matrix data load works. I haven't done too many of them, so I want to make sure I'm not missing the basics. 

The file I have has the year on one of the first lines in column 9.  The next row contains the headers with periods in 12 separate columns.

 

 

Is there an easy way to get the year from the first line (without a lot of code)?  Or should I get year based on the POV?  Then I am guessing a complex expression in the time columns to build the OS time key?  I know I can do all of this in code, but I don't want to skip over any out of the box functionality or best practices.

Any good guides on some of the best approaches with the Matrix load?

Thanks,

Scott

Data Integration
Data Sources
  • T_Kress's avatar
    T_Kress
    12 months ago

    You can set up a complex expression as shown below where you pull the year from the WF POV and then the months are your 12 columns:

    Otherwise, at the bottom of the matrix load you can specificy a header row if you want to read the year from the first row:

     

     

     

     

     

     

4 Replies

  • LeAnnTDang's avatar
    LeAnnTDang
    New Contributor III
    6 hours ago

    I have a load with similar data source setup. When I run the load through the Import step, it processed with no error, but nothing is returned after the import  job completed. Can you recommend what to look for? 

    (And thank you Teresa for responding to my question on another post)

    • T_Kress's avatar
      T_Kress
      Valued Contributor
      3 hours ago

      Maybe try to look at the log file to see if there is any information in that:

       

  • T_Kress's avatar
    T_Kress
    Valued Contributor
    12 months ago

    You can set up a complex expression as shown below where you pull the year from the WF POV and then the months are your 12 columns:

    Otherwise, at the bottom of the matrix load you can specificy a header row if you want to read the year from the first row:

     

     

     

     

     

     

    • ssmith-nova's avatar
      ssmith-nova
      Contributor
      12 months ago

      Thanks Teresa,

      That is what I had in mind, but I didn't want to over complicate it if I didn't have to.

      Scott