Forum Discussion

hoaphan's avatar
hoaphan
New Contributor III
4 years ago

Excel Load Data source (fixed files data source) does complex expressions works ?

Hello I've tried to load my excel file through the data source fixed files with a complex expression on the time dimension, and i think it doesn't go through the complex expression at all so i'm won...
Parsing
  • ckattookaran's avatar
    ckattookaran
    4 years ago

    You can do the following, create a parser rule and then use it like the following.

    SI#::[GetUserName]

hoaphan's avatar
hoaphan
New Contributor III

Could you please let me know how can i use a business rule for an excel load, where do you put the BR, in the excel template? because in the data source it doesn"t work 😕 what's the syntax please ? 
Other question, what type of BR do you create ? a Parser one or an XFBR String ? 
Thanks a lot for your help 🙂

ckattookaran's avatar
ckattookaran
VIP
4 years ago

You can do the following, create a parser rule and then use it like the following.

SI#::[GetUserName]

  • hoaphan's avatar
    hoaphan
    New Contributor III
    4 years ago

    Amazing i will try this 🙂
    Thanks a lot

    • ckattookaran's avatar
      ckattookaran
      VIP
      4 years ago

      Keep in mind that it does not work on the Amt column, even though the documentation shows an example of that.