you can use Pivoting node where pivoting column should be your CName column from table 1. Define Column name as Pivot name and Aggregation name as Keep original name(s). Then apply Reference Column Filter node.
Thanks for your Idea. But I am not able to configure the pivot node without error “Ambigious group/pivot column selection”
My configuration looks like this:
you can’t have same column as grouping and pivoting column. In your case you don’t need grouping column as only thing you want is to have values from CName column as column name so you can use Reference Column Filter node. Make sure to add any column into Manual Aggregation as node can’t be configured without it.