Forum Discussion

DJL's avatar
DJL
Regular Visitor
4 years ago
Solved

Combine files from different folders + Add a column with file path

Hi all,   I have a scenario where a monthly CSV dataset is generated from a system.  For audit purposes, this dataset is then stored into a corresponding monthly folder on SharePoint, eg: Jan 2022,...
Need Help
  • mussaenda's avatar
    mussaenda
    4 years ago

    Hi DJL,

     

    of course you can do that.

    If you are pulling data using Folder instead of single file,

    You can see these applied steps:

     

    then on the removed other columns,

    select also the folder path so it will not be removed.

     

     

    viola, job done.

     

    hope this helps.

     

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
4 years ago

Hi DJL,

 

of course you can do that.

If you are pulling data using Folder instead of single file,

You can see these applied steps:

 

then on the removed other columns,

select also the folder path so it will not be removed.

 

 

viola, job done.

 

hope this helps.

 

  • DJL's avatar
    DJL
    Regular Visitor
    4 years ago

    Hi Mussaenda,

     

    That's brilliant - works a charm!

     

    Thanks for the help, very much appreciated ðŸ˜Ž

     

    DJL