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

[Pang_Hee_Choy]

Hi All,

Issue: 

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

Example: 

File	Sheet Name	Data Type	Size
Book1	MTD 매출 조회	V_WString	9
Book2	MTD 매출 (KT&G)	V_WString	13

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.

example.yxzp

[CristonS]

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!