Hi, I have dataset that looks like: refper company placeholder_r0010 placeholder_r0020 placeholder_r0030 placeholder_r0040 201744 70912 . 71.889.742,2000000000 . 539.285,3600000000 26.431.317.719,6000000000 1.846.511.611,3300000000
201841 70912 . 85.787.103,2700000000 . 539.285,3600000000 26.066.828.054,7500000000 1.751.692.394,5900000000
201842 70912 . -43.904.340,3200000000 . 539.285,3600000000 26.937.620.831,9400000000 2.043.105.368,9100000000
201843 70912 . . . 537.775,2200000000 27.011.686.026,8700000000 1.215.625.799,2800000000 and another dataset which combines the placeholder column names with their actual names: Goodwill R0010
Deferred acquisition costs R0020
Intangible assets R0030
Deferred tax assets R0040 How do I combine these two sets such that the column names in the first dataset changes to names given in the second data set? (such that: placeholder_r0010 == Goodwill, placeholder_r0020 == Deferred acquisition costs, ...)
... View more