Append columns Power Query

[cristianml]

Hi,

I don´t understand why when I create an append with two columns it shows in 2 separeted columns. I need to append two columns from 2 different tables to use it for a List in Power Query to filter the data.  Is not simple as I have many relationships already in my model. It works in Power Bi but it should work also in PQ.

Follow the screenshots:

[az38 · Accepted solution]

Hi @cristianml 

you have a different column names. onewith ":" symbol, another - without

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn