Forum Discussion

Centaur's avatar
Centaur
Icon for Helper V rankHelper V
3 years ago
Solved

Add a Column to Excel source data

Hello,    I have a folder with many files (100's). I am consolidating these files with PQ (the data in each file is a table format) Same #columns and column field names in all the files.    I n...
Tips and Tricks
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    use my code replace all your code

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
2 years ago

use my code replace all your code

Centaur's avatar
Centaur
Icon for Helper V rankHelper V
2 years ago

thank you.  I was able to modify the current code.  It is tricky to do this.   I had to modify the 4th line of code but then had to change names for the following lines of code since they referenced names that no longer existed.  Not straight forward but I managed to do it.  thank you for the help.