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
Thank you
Can you share the input file? You can manually change the data and isolate just some rows with the problem.
@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 :)