Dynamic Input tool multiple txt file import issue

Question

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 	 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

Thank you

RRaoDannayak · Answer

@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 :)

Felipe_Ribeir0 · Answer

Hi @RRaoDannayak

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