Forum Discussion
Mic1979
Post Partisan
1 year agoCustomer Function Table.Combine
Dear all, I would need your support to solve this basic problem. I have this Custom Function: ( Input_Table as table, ColumnToRemove1 as text, ColumnToRemove2 as text, ColumnToRemove...
- 1 year ago
Hi Mic1979
Try with this
( Input_Table as table, ColumnToRemove1 as text, ColumnToRemove2 as text, ColumnToRemove3 as text, InputColumn1 as text, InputColumn2 as text, InputColumn3 as text, InputColumn4 as text ) => let // Replace null values with empty strings SourceNoNull = Table.ReplaceValue( Input_Table, null, "", Replacer.ReplaceValue, Table.ColumnNames(Input_Table) ), // Remove specified columns RemovedColumn = Table.RemoveColumns( SourceNoNull, {ColumnToRemove1, ColumnToRemove2, ColumnToRemove3} ), // Combine values from InputColumn1 and InputColumn2 into a new column "Helper_1" Helper_1 = Table.AddColumn(RemovedColumn, "Helper_1", each Text.Combine({Record.Field(_, InputColumn1), Record.Field(_, InputColumn2)}, ""), type text) in Helper_1
suparnababu8
Super User
1 year agoHi Mic1979
Try with this
(
Input_Table as table,
ColumnToRemove1 as text,
ColumnToRemove2 as text,
ColumnToRemove3 as text,
InputColumn1 as text,
InputColumn2 as text,
InputColumn3 as text,
InputColumn4 as text
) =>
let
// Replace null values with empty strings
SourceNoNull = Table.ReplaceValue(
Input_Table,
null,
"",
Replacer.ReplaceValue,
Table.ColumnNames(Input_Table)
),
// Remove specified columns
RemovedColumn = Table.RemoveColumns(
SourceNoNull,
{ColumnToRemove1, ColumnToRemove2, ColumnToRemove3}
),
// Combine values from InputColumn1 and InputColumn2 into a new column "Helper_1"
Helper_1 = Table.AddColumn(RemovedColumn, "Helper_1", each Text.Combine({Record.Field(_, InputColumn1), Record.Field(_, InputColumn2)}, ""), type text)
in
Helper_1