Forum Discussion

AlliedSol_Liz's avatar
AlliedSol_Liz
Frequent Visitor
1 year ago
Solved

Combining two columns with a / between them in Power Query

How would I take the two circled columns and combine them in Power Query with a / between them? I need PageReferrer.1.2 before pagePathPlusQueryString.  This data comes directly from GA4, so Power Qu...
Need Help
  • Fowmy's avatar
    Fowmy
    1 year ago

    AlliedSol_Liz 
    in Power Query, click on PageReferrer.1.2 press CTRL and click on pagePathPlusQueryString. under Transform tab, click Merge Column, choose as follows, provide a desired name:

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi AlliedSol_Liz,

Thanks for reaching out to the Microsoft fabric community forum.

 

It looks like you want to merge two column with a '/' separator between them. Please go through the solution provided by Fowmy. If it solves your issue, please accept it as solution.

 

I would also take a moment to thank Fowmy, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.