Data Visualization

Get Involved. Join the Conversation.

Topic

    Brian Hall
    Add Expression Filter in Data FlowAnswered
    Topic posted July 25, 2019 by Brian HallSilver Medal: 2,000+ Points, tagged Data Flows, Data Visualization 
    29 Views, 9 Comments
    Title:
    Add Expression Filter in Data Flow
    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
    Image:

    Best Comment

    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.

    Comment

     

    • 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 :) 

    • Brian Hall

      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)

        • Brian Hall

          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.

    • Lalitha Venkataraman

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