Add Expression Filter in Data Flow

Brian666H

Summary

Trying to add Expression Filter in a Dataflow

Content

I have a Data Flow with one column.  I want to SUM all values that are under 10.00.  I get an error. 

"Data element syntax incorrect, fully qualified path required. Example: "Sample Sales"."Facts"."Revenue""

See images

X_PAID_AMT >= 10.00   

Version

18 , Cloud

Gianni Ceresa

Hi,

Looks like the "expression" box has some issues in the validation. The column name is auto-completed while writing it, therefore it's right, but the expression expect the fully qualified name of a column (which at this point not sure what it could be as this step isn't based on a source directly but another step before).

As alternative could you maybe use the "standard" filter for that kind of logic? It works at least  

Gianni Ceresa

Looks like a fresh issue as it was working fine in OAC 105.1.0-217, while I have your same error in 105.3.0.

Brian666H

Bad screenshot on my part.  We need less 10 or less  "value<= 10.00"   I did try the range.  No error but the results were not right.   

Question where do I find the OAC version.  All I can find is the ADW version.

Gianni Ceresa

I see it in the cloud "My Service" console page, where I can start/stop the whole service. Still couldn't find the proper info in the front-end

In my few tests the range one did work (using only one of the 2 range to get it act as simple >= or <= and not like a BETWEEN).
Ideally you would need to raise a SR reporting the issue, as it's a regression hopefully they can fix it quite easily. 
(As I don't have a 105.3.0 right now in my own account I couldn't open the SR myself at the moment, will try to find a different way to get the info to Oracle)

Brian666H

This is the screen I get when I open My Service (see image).  I can't find a version number.   Odd.  Yes I'll open an SR

Gianni Ceresa

If you go in "Analytics" you will see a list of the instance you currently have. Click on the instance name representing the one you are using and there you must see the version.

Brian666H

Version:

105.3.0-100

Gianni Ceresa

Keep applying updates when they are available for that instance. 

I tested in a new release preview and it is fixed, you will be able to use the expression filter without the error.

Lalitha Venkataraman-Oracle

This is fixed in the upcoming version and you should be able to save the filter expression.