12-09-2021 12:01 PM - last edited on 05-25-2023 07:31 AM by JackLacava
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 wondering if i can use a complex expression in fixed file data source ?
The check i'm trying to do is to verify the workflow period and the time that's in my load file. if it's the same it can continue loading but if it's different i'm asking OS to pop up a error message.
If anyone has an idea please share it with me
Thanks 🙂
Solved! Go to Solution.
12-14-2021 11:58 AM
You can do the following, create a parser rule and then use it like the following.
SI#::[GetUserName]
12-10-2021 09:34 AM
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.
12-10-2021 10:42 AM
I don't think you can do an exception or show a pop-up message in transformation rules, you can write to the log, so maybe that is what you can do. I've used BRs in EXCEL load, never tried complex expressions.
12-14-2021 11:46 AM
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 🙂
12-14-2021 11:50 AM
You reference a BR from any particular dimension, in Logical Operator functional area.
12-14-2021 11:58 AM
You can do the following, create a parser rule and then use it like the following.
SI#::[GetUserName]
12-14-2021 11:59 AM
Amazing i will try this 🙂
Thanks a lot
12-14-2021 12:07 PM
Keep in mind that it does not work on the Amt column, even though the documentation shows an example of that.