Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Dynamic Input with .gz as template

kristic
7 - Meteor

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_AYX
Alteryx Alumni (Retired)

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
https://www.linkedin.com/in/adriley/
kristic
7 - Meteor

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

kristic
7 - Meteor

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