Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
  • shafiz_p's avatar
    shafiz_p
    2 years ago

    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!!



Anonymous's avatar
Anonymous
Not applicable
2 years ago

my requirement is establish a relation with another sheet so by adding a new column without using custom just by copying any existing one and changing the field from number to text

 

the above requirement is satisfied. but my question since i haven't used custom column only copy an existing one and made the changes...will the new column automatically introduced the changes i maded in this case a text after a refresh and numerous rows are created

 

hope i make myself clear

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    thanks. I had done this exercise already...