Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

I am trying to load budget data (which contains the 12 amounts in a single record, in multiple columns) from Excel using the import template, but unable to figure out the syntax for the column headers for the amounts.

Originally posted by Matthew DeCarlo

1/10/2020

I am trying to load budget data (which contains the 12 amounts in a single record, in multiple columns) from Excel using the import template, but unable to figure out the syntax for the column headers for the amounts. I have tried various formats but no luck. The latest version that I tried was: AMT#::[T#2019M1] AMT#::[T#2019M2]... I received an error indicating that there was no business rule [T#2019M1] . Any help would be appreciated.

Data Sources
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    5 years ago
    Originally posted by Chul Smith

    Needed to insert a blank column for AMT#