Start 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