07-09-2024 07:36 PM - edited 07-09-2024 07:40 PM
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
Solved! Go to Solution.
07-10-2024 12:10 PM - edited 07-11-2024 10:38 AM
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:
07-10-2024 12:10 PM - edited 07-11-2024 10:38 AM
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:
07-10-2024 12:14 PM
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