Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Find condition data between two tables in Power Query

Hello tod@s Please, I need your help, I have two tables, the first named "System" and the second named "Manual", both tables have a column called "Aux", where in both some data are repeated, I n...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    Try with the formula you indicate in the link, but there is something I must be doing wrong, because it throws me all the rows like "do not add"

    This is the code you enter

    = Table.AddColumn(#"Merged column inserted", "Custom", each let
    _col = [Aux],
    _tabla = Table.SelectRows(MANUAL,each [Aux]),
    _condicion = if _tabla = _col then "add" else "do not add"

    in
    _condicion)

    Please if you can help me correct, maybe the whole code this evil