Field types not working as expected

[Polite123]

Hi Team,

I have two macros wherein one macro is generating excel files A,B,C,D and has same headers in all 4 files.

Out of which 'A' excel file is union in the macro along with B,C,D and data types of all fields in ABCD are kept same USING SELECT TOOL.

Output of first macro is used as input to second.

However while running the second macro which consist of dynamic input to read 4 files ABCD, schema for BCD FILES  is not matching with the A excel file and throwing error B cd schema is not atching with first file in the set

I have checked for blank spaces and all preliminary checks has been done but still no use.

I have attached dummy data for reference

Please help in this regards.

Thanks

[binuacs · Accepted solution]

@Polite123 read all your input file using a batch macro instead of dynamic input tool, which will solve your issue. The below post will give you an idea about how to create a batch macro

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

[Polite123]

Thanks @binuacs for all your help and prompt response for all my queries.