Dynamically Read all Sheets - Getting error

[sriniprad08]

Hi Team,

Hope you are well. I need help please.

1) I am trying to import all the sheets in an excel file. - But its giving me schema error. Not sure whats the difference in sheets.

2) I would like to format few sheets (Due_Diligence_Images
Due_Diligence_Red_Flags_I
Due_Diligence_Red_Flags_II
Facility_Ranking)

in the below order after i read all of them.

1. User Name
2. Quiz Question ID
3. Quiz Question Name
4. Quiz Question Detail

Can you please help?

Please find attached the input, error and the alteryx flow,

Thanks

Sri

[binuacs · Accepted solution]

@sriniprad08 You should use the batch macro to read the sheet if you are getting the schema error

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

[sriniprad08]

Hi @binuacs ,

Great. Thank you for the help. Really appreciate your time. One more question please

if i would like to rearrange the data as mentioned my previous post what tool should i use after the batch macro please?

Thanks,

Sri

[binuacs]

@sriniprad08 use the select tool