I am just starting to work on using input data for filenames and am reformatting a date to give me an output file with the date embedded (yyyy-MM). That works well in this case since all rows are in the same month and I can just set the output to “Multiple files” by that column and it creates one file since all the rows are the same.
…that is until I came to a branch that has “Stats” in it and now the last row has an empty column where the filename is in the other rows - and that creates two files instead of one.
Is there any way to have that filename column repeat the same as all the other rows in the stats row?
use fill transformation
https://www.easydatatransform.com/help/latest/mac/html/index.html?fill.html
2 Likes
Ooohhh that works well. Thank you.
Didn’t know that exists.
Would probably be great if that would come up when searching for “copy” in the transforms.
That is easily fixed. Done.
great - now my chances increased in finding it again in a few months 