Forum Discussion
vanessafvg
Community Champion
Community Championcolumn names and data separate - append data to columns?
not sure if im overcomplicating this but i have a huge amount of data in compressed files in azure datalake, where i cannot make changes to the data, the columns name for this data i have separately...
101Mathew
Advocate V
Advocate VIn Power query can you not demote the columns titles to enable you to clean up the names, then pivot and re-name them if required?
- vanessafvg
101Mathew still left with the issue of the columns names not match so if you want to merge / append the data you need matching columns
