Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic Input tool multiple txt file import issue

RRaoDannayak
7 - Meteor

Hi Alteryx Forum,

 

I am trying to find the root cause for the issue to import the data from .txt file. I have a .txt file for Friday and Saturday with " " in it and i would like to combine these 2 data sets, the reason why i am using dynamic input tool is because i want the data sorted by the recent file from specific folder and get extracted by using dynamic input tool 

 

Issue: I am getting all the data i need but for some lines i am not getting the " " at the end which is kind of important to me 

 

Tried multiple ways to use different delimiters like \s and \t but they failed to get the data i need and they are changing the formats so, is there anyway to import the data from .txt as is without any missing quotes and stuff 

 

RRaoDannayak_0-1675193898351.png

Thank you

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @RRaoDannayak 

 

Can you share the input file? You can manually change the data and isolate just some rows with the problem.

RRaoDannayak
7 - Meteor

@Felipe_Ribeir0  Thanks for your response 
I can give you a sample 
Input file:
Account   Name   Balance Address  recurring Balance 
1234        Rahul     123.23   " "           " "

  The Dynamic input is showing me this 
Account   Name   Balance Address recurring Balance 
1234        Rahul     123.23   " "           "

Its removing the " " and showing it as " which is kind of wrong, I don't want to manually update it because its scheduled to run every monday at 06:00am. It's weird the way the input tool manipulated the data without me doing any changes or updates 

 

Sometimes Alteryx is rigid but trying to find a workaround :)

Labels
Top Solution Authors