Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Expression.Error: We cannot apply operator < to types Number and Text

Hello all, I have an below mentioned error

Expression.Error: We cannot apply operator < to types Number and Text

Details:
Operator=<
Left=4
Right=Q9_1

 

I get this while Pivoting , attached the query below

let
Source = #"Data 1 Sheet",
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Test Name", "Consumer", "Serving Position", "3_digit_Product_Code", "Sample_Name", "Unique Consumer ID", "Unique Product Code"}, "Attribute", "Value"),
#"Filtered Rows1" = Table.SelectRows(#"Unpivoted Other Columns", each Text.EndsWith([Attribute], "_JAR") or Text.Contains([Attribute], "JAR") or Text.Contains([Attribute], "jar") or Text.Contains([Attribute], "Jar")),
#"Added Conditional Column" = Table.AddColumn(#"Filtered Rows1", "Custom", each if [Value] = 1 then "Too Less" else if [Value] = 2 then "Too Less" else if [Value] = 3 then "Just About Right" else if [Value] >= 4 then "Too Strong" else null),
#"Inserted Literal" = Table.AddColumn(#"Added Conditional Column", "Literal", each 1),
#"Changed Type" = Table.TransformColumnTypes(#"Inserted Literal",{{"Literal", Int64.Type}}),
#"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Custom]), "Custom", "Literal")
in
#"Pivoted Column"

 

Can someone help to solve this error, Thanks!

  • Hello - Power Query is finding a text value when it expects a number.  Based on your script, I would think that it is in the 'Value' column.  I recomend you use Table.FindText before the #"Added Conditional Column" step to locate it.  The text value causing the problem is 'Q9_1'.  

    Table.FindText ( #"Filtered Rows1", "Q9_1" )

     

2 Replies

  • Hello - Power Query is finding a text value when it expects a number.  Based on your script, I would think that it is in the 'Value' column.  I recomend you use Table.FindText before the #"Added Conditional Column" step to locate it.  The text value causing the problem is 'Q9_1'.  

    Table.FindText ( #"Filtered Rows1", "Q9_1" )

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello jennratten . Yes there is text value in the Value column, that causes this error.

    Thanks for helping me out 👍