Forum Discussion
Anonymous
7 years agoNot applicable
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...
- Anonymous7 years agoSolution:
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)
TeigeGao
Solution Sage
7 years agoHi Anonymous ,
Could you please tell us what's the problem you meet when using the if function?
Best Regards,
Teige
- Anonymous7 years agoNot applicableSolution:
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)