SOLVED
Inputs Data Type
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JJJJC
7 - Meteor
‎01-20-2022
07:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi,
I am tasked to input all files from a folder. But Column A in one of the files is treated as a different data type which stopped it from being inputted into my workflow. How can I resolve this?
Input tool on all files - reading from \[folder name]\*.xlsx
File No.5 is not read in here
file that has a different type:
Solved! Go to Solution.
Labels:
- Labels:
- Developer
- Developer Tools
- Input
4 REPLIES 4
22 - Nova
‎01-20-2022
07:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JJJJC
Try this macro it will read all the files sheets.
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480
Hope this helps : )
‎01-20-2022
12:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
‎01-20-2022
10:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @JJJJC
Cheers and have a nice day!
‎04-21-2022
01:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
[Removed comment]
