How to handle the same scenario but multiple Excel workbooks with multiple sheets (but sheet1, sheet2.. sheetN schema is the same all workbooks). But want to merge sheet1 data from all workbooks to CSV and the same with the rest of the sheets. Please let me know - thanks Example: workbook1 name - India (sheet1 - batters, sheet2 - bowlers, sheet3 - coaching staff) workbook2 name - Australia (sheet1 - batters, sheet2 - bowlers, sheet3 - coaching staff) . . workbook5 name - New Zealand (sheet1 - batters, sheet2 - bowlers, sheet3 - coaching staff) Output: Batters.csv -> Workbook1.sheet1 + Workbook1.sheet1 + .... + Workbook5.sheet1 Bowlers.csv -> Workbook1.sheet2 + Workbook1.sheet2 + .... + Workbook5.sheet2 Coaching Staff.csv -> Workbook1.sheet3 + Workbook1.sheet3 + .... + Workbook5.sheet3
if we have more than two sheets, N number of sheet then @createArray('Emp', 'Training') will it work as you showing in recording, how will pass every sheet name
That is called multi dependency trigger file. In such cases we need to use audio table and check run status for today if it is already ran for today based on first all subsequent runs pipeline should skip Other way is we can use schedule trigger instead of event based and check whether latest files loaded in folder if you find latest files in folder then you start your process else wait using wait activity and keep checking for 15mins etc..there are lot of ways to discuss. We have live webinar sessions which you can attend to clarify them
How to handle the same scenario but multiple Excel workbooks with multiple sheets (but sheet1, sheet2.. sheetN schema is the same all workbooks). But want to merge sheet1 data from all workbooks to CSV and the same with the rest of the sheets. Please let me know - thanks
Example:
workbook1 name - India (sheet1 - batters, sheet2 - bowlers, sheet3 - coaching staff)
workbook2 name - Australia (sheet1 - batters, sheet2 - bowlers, sheet3 - coaching staff)
.
.
workbook5 name - New Zealand (sheet1 - batters, sheet2 - bowlers, sheet3 - coaching staff)
Output:
Batters.csv -> Workbook1.sheet1 + Workbook1.sheet1 + .... + Workbook5.sheet1
Bowlers.csv -> Workbook1.sheet2 + Workbook1.sheet2 + .... + Workbook5.sheet2
Coaching Staff.csv -> Workbook1.sheet3 + Workbook1.sheet3 + .... + Workbook5.sheet3
If you got the answer please let me know
How to get dynamically sheet names in the array instead of giving sheet names?
Is we have empty header columns in few tabs. How to handle it dynamically?
if we have more than two sheets, N number of sheet then @createArray('Emp', 'Training') will it work as you showing in recording, how will pass every sheet name
How do we do this if we do not know the sheetname and it changes for every instance
If customer placed more files, how event based trigger will work?
Please post video. Thanks for your video
That is called multi dependency trigger file. In such cases we need to use audio table and check run status for today if it is already ran for today based on first all subsequent runs pipeline should skip
Other way is we can use schedule trigger instead of event based and check whether latest files loaded in folder if you find latest files in folder then you start your process else wait using wait activity and keep checking for 15mins etc..there are lot of ways to discuss. We have live webinar sessions which you can attend to clarify them
@@Cloudpandith how to connect with you. Are you providing session?
Thanks
@@aslamnaturalfarming2128 current workshop is closed
@@aslamnaturalfarming2128you can check our website www.cloudpandith.com to get more details
@@Cloudpandith thank you