Dynamic Input with .gz as template

[kristic]

I am using a dynamic input tool to import monthly files that are *.txt.gz

I am using the directory tool to create the list and bring them into the dynamic input.

I set the template to the first .txt.gz file that I imported

I am trying to update the import on:

Field: Filename

Action: Change File/Table Name

When I attempt that or 

Field: Full Path

Action: Change Entire File Path

It only imports my template file and not the filename I am bringing in from the directory tool.

(Yes I have triple checked it is bringing in the right filenames)

I feel like this is an issue since updating to Server 2021.1  

Is anyone else having this issue as well?

[AdamR_AYX · Accepted solution]

Hi @kristic 

I think this is because the file xml for gz files looks like this

C:\Workflows\gz\File1.txt.gz|||datafile.csv

So replacing with full path loses that |||datafile.csv

I could get it to work by adding that bit in using a formula tool.

Check out the attached workflow.

Best regards

Adam

[kristic]

Thank you Adam, I will give it a try!!

[kristic]

Worked like a charm!  Thank you so much!!!

[Monika-1988]

Thanks AdanR,

This works well. by using this workflow can i get output in .xlsx?