Hi Guys,
How do I rename a column within a nested collection.
Example collection A, has a nested collection within column header age.
I want to change the column value within Collection A nested collection Age column Result to Output
RenameColumns(A,Age ,"Result ", "Output")
Tried this although does not work.
Any help is greatly appreciated.
Thanks
Hi @christian12 ,
I assume there is a collection:
ClearCollect(
A,
{Id:1,Age:Table({Result:"1"})},
{Id:2,Age:Table({Result:"1"},{Result:"2"})}
);
You could use this formula to rename the 'Result' to 'Output':
GroupBy(RenameColumns(Ungroup(A,"Age"),"Result","Output"),"Id","Age")
Best Regards,
Bof