Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamic Column Name (M/PowerQuery) Difficulty

Hi all,   I am importing many files (with the same structure from a folder). These files automatically append to each other.   I required to change  one of the column names based on it's index po...
  • Anonymous's avatar
    Anonymous
    7 years ago
    Solution:
    When you import fikes from Share point a sample file is created. You can set which file you like to be selected as your first query.

    I can now ensure my first query containta the relevant headers :)

    (For the if statement, I still cant set the word as it will say you already have this word)