Forum Discussion

ScottCharles's avatar
ScottCharles
New Contributor II
10 months ago

Importing XFD multiple amount columns

Hello,  I'm hoping someone can help me with a syntax issue where I have data in a spreadsheet that is organized with accounts on the rows and 12 periodic months in the columns. I want to be able to...
Data Integration
Data Sources
Import
  • JoakimK's avatar
    JoakimK
    10 months ago

    You have to use the Matrix load to achieve what you are wanting to do. So if you change the Column tag from T#:[2024M1] to instead say T#:[]:[]:[2024M1] then the next one T#:[]:[]:[2024M2] and so on, it should work.

    Joakim

ScottCharles's avatar
ScottCharles
New Contributor II
10 months ago

Thanks JoakimK, I tried your suggestion and it worked! For other users wanting to use this method you also need to specify AMT#:[] in your dimensions as OneStream will require that as well.