Multiple Excel Sheets
- Suscribirse a un feed RSS
- Marcar tema como nuevo
- Marcar tema como leído
- Flotar este Tema para el usuario actual
- Favorito
- Suscribir
- Silenciar
- Página de impresión sencilla
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
Hi All,
I have an excel file with multiple sheet names. I want to read all excel sheets information. I have tried with community examples it is working on my desktop. when i move same workflow to shared folder. it is not working. I have tried with multiple ways examples avilable in community. Please suggest any other way can i read all sheets details.
Thanks in Advance,
Niranjan
¡Resuelto! Ir a solución.
- Etiquetas:
- Batch Macro
- Best Practices
- Developer
- Input
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
Any suggestions please
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
If your sheets are of the same data format (meaning, the fields - i.e the columns are of the same name, same data type, and of the same length), then you can use a Dynamic Input tool to call all of it in.
Otherwise, you can also use a Batch Macro to do the job.
Refer to documentation below:
- https://help.alteryx.com/20231/designer/batch-macro#:~:text=A%20Batch%20macro%20runs%20multiple,to%2....
- https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Batch-Macro-Input-Multiple-She...
- https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-To-Import-Multiple-Exce...
If you're still stuck, you can provide us with some sample data and we can show you also.
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
@caltang thank you so much for detailed explanation.
Any best example workflow you give me.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
Can you provide some data?
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
@caltang I do not have access upload/send an emails. I'm doing it from my mobile. Tomorrow I can upload sample data with personal laptop.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
@caltang Please find the attached sample data, Im unable to read multiple sheets details. Please help me.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
@caltang I could see sheet1 data 4 times. i want to fetch multiple sheets data. Please suggest me do i need to select any other option.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
Here you go! Made it more dynamic. @NiranjanK1
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- « Anterior
- Siguiente »