Just to be sure as your example is not a reprex (if you could make one it would be awesome): how many columns are there in frpm ? You are renaming all to "CDS_CODE" here I think.
In your previous code you rename just one column
Is there something off here or do I misunderstood?
Please a reprex is needed here. It will help us help you and I think it will help you while trying to build the reprex. Thanks.