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
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:
