I am learning EasyMorph. I have a task to take results from a SQL server stored procedure, export the results into excel showing a seperate tab for each ClientID. I was using Iterate and it was working but I was putting all the data into a excel spreadsheet in the main data pull, then iterating through the client ID and creating a seperate tab for each Client ID. This worked great, but the request does not want all the data on the first tab. So I used the Excel (experimental) action to delete the sheet1 with all the clients on it. This worked great, but then when I deployed it to the EasyMorph Server, the Delete tab was not working. I now have it working but I had to hard code the clientID and derrive a table for each clientID then write to excel in each derrived table using synchronize.
I like the way the itteration was working because it was dynamic and didn’t matter how many clientID’s I have. Is there a way to use the itteration without writting a table before the itteration part starts? I will attach some sample data for the sql pull and sample data for results. Please advise on the best approach for this. We want to schedule this through EasyMorph server once it’s working correctly.
Any advice for a newbie is greatly appreciated.