Output file name based on column

Question
1

I have split a file into many smaller files, each of which is for a specific territory (the territory ISO code is stored as a column). Is there a way I can take the territory column value and append it to the filename?

Eg

file 1: filename_AR

file 2: filename_AT

file 2: filename_AU etc

2

So you are splitting by row values as per example 2 here?:

Just use Concat Cols to add the territory code column to the file name. You might need to Split Col first to separate the file name and extension first.

1 Like
3

That worked perfectly, thank you!

1 Like