Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to replace a value in a column with the column name

Hi there,

 

Could someone please tell me how I can replace values in a column with the column name.

 

As a simple example, I want PQ to replace every 'Nein' with the column name:

 

Nigel_Mayhew_0-1635401822618.png

 

Is this doable?

 

Thanks.

1 ACCEPTED SOLUTION

NewStep= Table.ReplaceErrorValues(PreviousStepName,List.Transform(Table.ColumnNames(PreviousStepName),(x)=>{x,x}))

View solution in original post

4 REPLIES 4
wdx223_Daniel
Super User
Super User

NewStep=Table.TransformColumns(PreviousStepName,List.Transform(Table.ColumnNames(PreviousStepName),each {_,(x)=>if x="Nein" then _ else x}))

Anonymous
Not applicable

Hi Daniel,

 

It works perfectly! Thank you!

 

How can I please apply your solution when I want to replace errors, instead of a specific value, with the column name?:

 

Nigel_Mayhew_0-1635404143005.png

 

Looking forward to hearing back from you.

 

NewStep= Table.ReplaceErrorValues(PreviousStepName,List.Transform(Table.ColumnNames(PreviousStepName),(x)=>{x,x}))

Anonymous
Not applicable

Genius. Thanks very much!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors