none
[FlexExtractor] Can't join. The expressions must both be columns

    Question

  • Hi everyone, I am working on a proyect with hundred of columns. After reading the doc I found a flex extractor to help with this problem. The extractor was working perfectly with one table. The problem starts with joinning tables, I am getting this error when compile:

    "Error E_CSC_USER_JOINCOLUMNSEXPECTEDONEACHSIDEOFCONDITION: The expressions map[0] and map_2[0] on each side of the comparison must both be columns."

    I have two extractors like this:

    @data = EXTRACT map SqlMap<Int32,string>
            FROM @input
            USING new USQLFlexExtractor.FlexExtractor();

    @data_2 = EXTRACT map_2 SqlMap<Int32,string>
            FROM @input_2
            USING new USQLFlexExtractor.FlexExtractor();

    @output =  SELECT map[0], map[2], map_2[1]
    FROM @data AS data
    LEFT JOIN @data_2 AS data_2 ON map[0] == map_2[0]

    Any ideas why? 

    Regards

    Monday, January 22, 2018 7:25 PM