Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
I finally discovered the error.
To be able to create a concatenated column in PQ, it must only be text, IT CANNOT BE NUMBER
What I need is to join "S" & (Center)
But it gives me error as seen in the following image:
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
I still get an error "Eof token expected"
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |