Need Help

[Anonymous]

Hi All

I have a two text columns in the table, but i need to combine the two text columns make it as one in power Query

Below are the examples in the below table i have Name column and New Name Column. I need to combine the two columns and the condition is where ever New Name having the text it needs to be come othere wise Name has to come in Power Query  ,like Result Column name in Below Image. Please find the Image for your refrence

Thanks!! Nagaraju 

[Anonymous]

@Anonymous 
Please clarify the logic by adding a few more rows in the sample. I only see the result = column2. For now, you can also try:

= if Text.Contains([Column1],[Column2]) then [Column2] else [Column1]

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Samarth_18]

Hi @Anonymous 

Your question is not very clear. Based on my understanding you can create a custom column with below code in power query:-

if [new_name] <> null 
then [new_name]
else [name]

Let me know if this is the expected output?

Thanks,

Samarth