Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Input Tool - Excel - List of Sheet Names (Error in multiple file due to data size)

Hi All,

 

Issue: 

 

When input <List of Sheet Names>, Alteryx will assign data type and size accordingly.

 

Example: 

FileSheet NameData TypeSize
Book1MTD 매출 조회V_WString9
Book2MTD 매출 (KT&G)V_WString13

 

It become a problem, when input with multiple files with wildcard (Input file Book*xlsx).

It will be skipped due to "has a different schema than the 1st file in the set and will be skipped"

 

Solution:

Very simple, always same data type and size, like in formula tool. V_Wstring, with size 1073741823.

2 Comments
CristonS
Alteryx Alumni (Retired)

Your idea and feedback are appreciated! Our product team is constantly striving to make our products better, and the user feedback we received is critical in that mission. This idea will be reviewed and commented on by Alteryx when the necessary criteria are met.  And "Like" the other ideas you'd like to see in the product! 

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes