Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need Help

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 

Need Help

2 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.