Join a letter to a column in Power Query

[Syndicate_Admin]

Community

Please ask for your help with knowing how to write the formula in Power Query if I want to generate a new column with the one letter along with the value of a current column.

Example:

"S" [Center], where S is the letter and [Center] is the column of a current table.

Currently I enter it like this but it generates error.

Stay tuned

Saludso

[v-luwang-msft · Accepted solution]

Hi @Syndicate_Admin ,

Pls refer the below:

If the column is number ,use the below to create a new column ,then delete before column and rename new column:

"S"&Number.ToText([Center1])

If the column is text,use the below to create a new column ,then delete before column and rename new column:

"S"&[Cebter2]

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Syndicate_Admin]

I finally discovered the error.

To be able to create a concatenated column in PQ, it must only be text, IT CANNOT BE NUMBER

[Syndicate_Admin]

What I need is to join "S" & (Center)

But it gives me error as seen in the following image:

[ribisht17]

@Syndicate_Admin 

StepName = Table.TransformColumns(
  Source,
  {
    {
      "name", 
      each 
        Text.Combine({"ABC",(_)}),
      type text
    }
  }
)

>>>REFER >>> Add Text to an Existing Column in Power Query | jaykilleen.com

Regards,

Ritesh 

[Syndicate_Admin]

I still get an error "Eof token expected"