Matrix Data Load Basics

Question

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

T_Kress · Accepted Answer

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:

LeAnnTDang · Answer

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)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded