Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Slect Data from column name specified in different column

Hi all! So I have and issue. So In SelectFromTable I have a table that I wish to filter. In ColumntoSelect I have column name that needs filtering. Now, im using Power query in Excel. a...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hi, Anonymous try to replace first parameter of Expression.Evaluate with

    "Table.SelectRows(tabla_a_evaluar,each " & columna_para_filtrar & " <> ""A"")"

     

AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago

Hi, Anonymous try to replace first parameter of Expression.Evaluate with

"Table.SelectRows(tabla_a_evaluar,each " & columna_para_filtrar & " <> ""A"")"

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This worked!
    Thank you so so much,
    Now if you could why the double quotes worked when actualy double quating like this is equal to no quates at all?
    Thats what im not getting.

    • AlienSx's avatar
      AlienSx
      Icon for Super User rankSuper User
      3 years ago

      2 quotation marks in a row withing a string (which is in between double quotes itself) gives you single quotation mark in string. If it were not for Expression.Evaluate you would write smth like

      Table.SelectRows(tbl, each [columnA] <> "A") e.g. with quotation marks. So we need to emulate this string in Expression.Evaluate. Try this in Advanced Editor

      let
    Source = {"double quotes", " ""double quotes "}
in
    Source