Forum Discussion
hoaphan
4 years agoNew Contributor III
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...
- 4 years ago
You can do the following, create a parser rule and then use it like the following.
SI#::[GetUserName]
hoaphan
4 years agoNew 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
4 years agoValued Contributor
You can do the following, create a parser rule and then use it like the following.
SI#::[GetUserName]
- hoaphan4 years agoNew Contributor III
Amazing i will try this π
Thanks a lot- ckattookaran4 years agoValued Contributor
Keep in mind that it does not work on the Amt column, even though the documentation shows an example of that.