= Table.AddColumn(Source, "Custom Column", each Record.Field(_, [Column Name])) General Use: Dynamically extracts a specific field from a record in each row of a table, based on a given column name.
Based on the "Column Name" it returns one among the other 3 columns (G, H, I)... for example the first line is "Supplier" so in the "Custom Column" returns "Tokyo Traders".
= Table.AddColumn(Source, "Custom Column", each Record.Field(_, [Column Name]))
General Use: Dynamically extracts a specific field from a record in each row of a table, based on a given column name.
Awesome 🎉
Wow
thanks to my practices
to learn with sample file
thanks youuuu
great !! thanks from Italy
Based on the "Column Name" it returns one among the other 3 columns (G, H, I)... for example the first line is "Supplier" so in the "Custom Column" returns "Tokyo Traders".
Not sure of what's going on
Can you say what is going on here?
Whats happen?