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]

Koemets's avatar
Koemets
Contributor
4 years ago

The file preview (the first screenshot) should look like legit data, it's pretty much what you see is what you get. And it looks like gibberish now, so I believe the system simply doesn't recognize the values. Please check your file and datasource setting first. You should eventually see a valid grid, with columns and readable datarows.