Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Table.SelectColumns error

I am using Power Query Editor's Custom Column window to attempt the following; I have Table1 and Table2. I am trying to add a custom column to Table1, that contains Table2 as the value, but only if ...
Need Help
  • jbwtp's avatar
    jbwtp
    3 years ago

    Hi Anonymous,

     

    Assuming that your example is in th econtext of Table.AddColumn() the behaviour is quite weird.

    Do you want to try to split the formula to something like:

    t2 = Table.SelectColumns(#"Table2", {"Column1", "Column2"}),
t1 = Table.AddColumn(..., ..., each if [ValueFromThisTable] = null then null else t2)

    and see if this works Ok?

     

    Thanks,

    John

jbwtp's avatar
jbwtp
Memorable Member
3 years ago

Hi Anonymous,

 

Assuming that your example is in th econtext of Table.AddColumn() the behaviour is quite weird.

Do you want to try to split the formula to something like:

t2 = Table.SelectColumns(#"Table2", {"Column1", "Column2"}),
t1 = Table.AddColumn(..., ..., each if [ValueFromThisTable] = null then null else t2)

and see if this works Ok?

 

Thanks,

John

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Well it turns out I just needed to refresh Power Query Editor, the values have always been there they just were showing null. Found this out after trying your version and multiple variations of each step, one by one until it broke. It always broke once I clicked to view one of the tables to validate the data however an expansion of the table reveals its all there. 

     

    Very odd