Is there a transformation that I could use to merge different text files in a folder into 1 data table ?
If not, could this be added as this seems a very useful function to have.
Every import transformation allows loading multiple uniform files at once and appending them automatically into one table. See the tutorial: Loading data from files