Output multiple files based on number of files in input folder

Question

I have 2 inputs - A and B.

* A - folder with multiple files.
* B- single file

Based on these inputs I created a workflow. The output is based on a template file ( the headers are taken from the template file)

So the output should be basically 1 file for each input in A folder such that it has column headers from template and below that the data will be populated.

I am trying to achieve this but I'm getting only the data populated in the range. The headers are missing in their positions.

Can anyone guide me through this?

Dhrish · Answer

@Inactive User in the last snip it has the config of input tool. In that I have selected Fullpath for Output Filename as Field, this will give the full path of the File which gets only the fullpath without the sheet name.

Qiu · Answer

@Inactive User 
I think we can choose to output the FileName when using the Data Input tool.

unknown · Answer

@Dhrish from where have u taken the filename column in formula tool?