Forum Discussion
Change value by header name
Hello, Is there any way to replace the value of a cell with the Header Name for different columns at the same time? I have multiple columns when the value is Yes, and I need to change this ...
how about this solution?
let Quelle = Excel.CurrentWorkbook(){[Name="PFC"]}[Content], #"Tiefer gestufte Header" = Table.DemoteHeaders(Quelle), #"Transponierte Tabelle" = Table.Transpose(#"Tiefer gestufte Header"), ListHeader = List.RemoveFirstN(Table.ColumnNames(#"Transponierte Tabelle"),1), ErsetzterWert = Table.ReplaceValue(#"Transponierte Tabelle","Yes", each _[Column1],Replacer.ReplaceText,ListHeader), #"Transponierte Tabelle1" = Table.Transpose(ErsetzterWert), #"Höher gestufte Header" = Table.PromoteHeaders(#"Transponierte Tabelle1", [PromoteAllScalars=true]) in #"Höher gestufte Header"Melanie
OK. Then instead of
(col) => {col, each _ & " " & col, type text}use
(col) => {col, each if _ = "Yes" then col else _, type text}
Yes sure:
Initial data
| Title | Name 1 | Name 2 | Name 3 | Name 4 |
| A | Yes | No | No | Yes |
| B | No | Yes | No | Yes |
Expected outcome
| Title | Name 1 | Name 2 | Name 3 | Name 4 |
| A | Name 1 | No | No | Name 4 |
| B | No | Name 2 | No | Name 4 |
OK. Then instead of
(col) => {col, each _ & " " & col, type text}use
(col) => {col, each if _ = "Yes" then col else _, type text}Thanks, this is correctly working