Forum Discussion
Question on Replace Function
Hi, I add a new column by copying an existing one and changing the format from numbers to text (copied year column and division new one) then add my text as shown so that i can create a relations...
Anonymous Put comma inside a double quotation and use & like below:
Date.ToText([Invoice Date]) & " , " & [Comments]Hope this answered your question. If, please mark it as a solution!!
Select the column you want to copy.
Right-click on the column header and select Duplicate Column. This will create a new column with the same values as the original.
Select OrderID_Text.
Go to the Transform tab.
Click on Data Type and select Text
When steps are recorded in Query editor than new data will also be updated you can follow this method
thanks. I had done this exercise already...