Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dynamic Input with .gz as template

kristic
6 - Meteoroid

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?

 

4 REPLIES 4
AdamR
Alteryx
Alteryx

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

Adam Riley
Principal Software Engineer
Tech Lead Core Engines, Alteryx
kristic
6 - Meteoroid

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

kristic
6 - Meteoroid

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

Monika-1988
5 - Atom

Thanks AdanR,

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

Labels