# \#ps-steps **URL:** https://community.automationedge.com/tag/ps-steps/71.md [Latest](https://community.automationedge.com/latest.md) · [Categories](https://community.automationedge.com/categories.md) · [Tags](https://community.automationedge.com/tags.md) --- ## [Intermediate Process Studio](https://community.automationedge.com/t/intermediate-process-studio/17854)
**Author:** [@sudeshna](https://community.automationedge.com/u/sudeshna)\ **Replies:** 1\ **Last updated:** [October 15, 2026, 3:43am UTC](https://community.automationedge.com/t/intermediate-process-studio/17854 "2026-10-15T03:43:15Z")
How to deploy a project from Process Studio to AutomationEdge Server? --- ## [How to fetch a single record at a time from a excel file input using loop?](https://community.automationedge.com/t/how-to-fetch-a-single-record-at-a-time-from-a-excel-file-input-using-loop/17829)
**Author:** [@Siddharth\_31122002](https://community.automationedge.com/u/Siddharth_31122002)\ **Replies:** 1\ **Last updated:** [October 15, 2026, 3:38am UTC](https://community.automationedge.com/t/how-to-fetch-a-single-record-at-a-time-from-a-excel-file-input-using-loop/17829 "2026-10-15T03:38:35Z")
I have a excel file which contains 3 records, I need to fetch a single record at a time inside a loop and then perform certain operations on it and then fetch the next record? How can I achieve this? --- ## [Server Credential](https://community.automationedge.com/t/server-credential/17861)
**Author:** [@sudeshna](https://community.automationedge.com/u/sudeshna)\ **Replies:** 1\ **Last updated:** [October 8, 2026, 9:51am UTC](https://community.automationedge.com/t/server-credential/17861 "2026-10-08T09:51:31Z")
Hi Team, I am unable to access AutomationEdge server due to credential issue. Could you please guide where to check or update server credentials? Thanks! --- ## [How to convert weekday to word, like 1 Mon, 2 Tue](https://community.automationedge.com/t/how-to-convert-weekday-to-word-like-1-mon-2-tue/17544)
**Author:** [@kshriniwas](https://community.automationedge.com/u/kshriniwas)\ **Replies:** 1\ **Last updated:** [September 30, 2026, 9:47am UTC](https://community.automationedge.com/t/how-to-convert-weekday-to-word-like-1-mon-2-tue/17544 "2026-09-30T09:47:35Z")
we mostly print days of week as word --- ## [Issue while populating Excel columns dynamically in Microsoft Excel Input using Get File Names output in AutomationEdge Process Studio](https://community.automationedge.com/t/issue-while-populating-excel-columns-dynamically-in-microsoft-excel-input-using-get-file-names-output-in-automationedge-process-studio/17937)
**Author:** [@kaneez03](https://community.automationedge.com/u/kaneez03)\ **Replies:** 1\ **Last updated:** [September 29, 2026, 9:08am UTC](https://community.automationedge.com/t/issue-while-populating-excel-columns-dynamically-in-microsoft-excel-input-using-get-file-names-output-in-automationedge-process-studio/17937 "2026-09-29T09:08:12Z")
Hi everyone, I am facing an issue while dynamically reading an Excel attachment in AutomationEdge Process Studio . Current workflow: Email Messages Input → Get File Names → Rename Fields → Microsoft Excel Input … --- ## [Need Better Approach for Excel Header Validation in Automation Workflow](https://community.automationedge.com/t/need-better-approach-for-excel-header-validation-in-automation-workflow/17940)
**Author:** [@amolbhosale](https://community.automationedge.com/u/amolbhosale)\ **Replies:** 1\ **Last updated:** [September 29, 2026, 5:20am UTC](https://community.automationedge.com/t/need-better-approach-for-excel-header-validation-in-automation-workflow/17940 "2026-09-29T05:20:11Z")
Is there any configuration available in the Microsoft Excel Input plugin for validating headers? I tried the following approaches: 1. Read based on the column index In this approach, headers cannot be validated. 2. … --- ## [Workflow Executor not returning Result Rows from Shared Workflow](https://community.automationedge.com/t/workflow-executor-not-returning-result-rows-from-shared-workflow/18085)
**Author:** [@kaneez03](https://community.automationedge.com/u/kaneez03)\ **Replies:** 1\ **Last updated:** [September 22, 2026, 11:15am UTC](https://community.automationedge.com/t/workflow-executor-not-returning-result-rows-from-shared-workflow/18085 "2026-09-22T11:15:23Z")
Hi everyone, I’m practicing for the AutomationEdge Developer Certification and I’m stuck with Shared Workflow execution. Scenario I have created a shared workflow (WF\_Validate\_Bookings) and a main workflow (WF\_Main\_Tr… --- ## [What is the difference between Stream Lookup and Database Lookup?](https://community.automationedge.com/t/what-is-the-difference-between-stream-lookup-and-database-lookup/17835)
**Author:** [@nishaautade](https://community.automationedge.com/u/nishaautade)\ **Replies:** 1\ **Last updated:** [April 25, 2026, 10:00am UTC](https://community.automationedge.com/t/what-is-the-difference-between-stream-lookup-and-database-lookup/17835 "2026-04-25T10:00:45Z")
What is the difference between Stream Lookup and Database Lookup? --- ## [How to calculate discount of books](https://community.automationedge.com/t/how-to-calculate-discount-of-books/11971)
**Author:** [@Rupali\_Shinde](https://community.automationedge.com/u/Rupali_Shinde)\ **Replies:** 3\ **Last updated:** [April 12, 2026, 7:31pm UTC](https://community.automationedge.com/t/how-to-calculate-discount-of-books/11971 "2026-04-12T19:31:45Z")
how to calculate discount of books if there condition like a calculate discount 18% and 10% above \< no of books quantity. can you please help bcoz i haven’t knowledge about AE tool im just started to learning. Thank… --- ## [How to extract multiple products from a web page using a loop in AutomationEdge?](https://community.automationedge.com/t/how-to-extract-multiple-products-from-a-web-page-using-a-loop-in-automationedge/17739)
**Author:** [@Ankit\_99](https://community.automationedge.com/u/Ankit_99)\ **Replies:** 1\ **Last updated:** [March 27, 2026, 12:40pm UTC](https://community.automationedge.com/t/how-to-extract-multiple-products-from-a-web-page-using-a-loop-in-automationedge/17739 "2026-03-27T12:40:09Z")
Hi Team, I need to extract multiple product details from a web page where data is shown in card/div format (not a table). Which activity should I use, and how can I loop through multiple elements dynamically using the … --- ## [How can i manage rows to columns](https://community.automationedge.com/t/how-can-i-manage-rows-to-columns/17727)
**Author:** [@sohampatil](https://community.automationedge.com/u/sohampatil)\ **Replies:** 1\ **Last updated:** [March 26, 2026, 12:58pm UTC](https://community.automationedge.com/t/how-can-i-manage-rows-to-columns/17727 "2026-03-26T12:58:46Z")
so what i did mistake and what i need to use --- ## [What is difference between Apache POI and Apache POI streaming](https://community.automationedge.com/t/what-is-difference-between-apache-poi-and-apache-poi-streaming/17692)
**Author:** [@kshriniwas](https://community.automationedge.com/u/kshriniwas)\ **Replies:** 1\ **Last updated:** [March 22, 2026, 3:23pm UTC](https://community.automationedge.com/t/what-is-difference-between-apache-poi-and-apache-poi-streaming/17692 "2026-03-22T15:23:54Z")
In Excel Input we have these two engine options and when should we use them. --- ## [How to select only .xlsx files in some directory and move them to destination](https://community.automationedge.com/t/how-to-select-only-xlsx-files-in-some-directory-and-move-them-to-destination/17689)
**Author:** [@kshriniwas](https://community.automationedge.com/u/kshriniwas)\ **Replies:** 1\ **Last updated:** [March 12, 2026, 9:22am UTC](https://community.automationedge.com/t/how-to-select-only-xlsx-files-in-some-directory-and-move-them-to-destination/17689 "2026-03-12T09:22:14Z")
Suppose we have some directory containing files then how can we move .xlsx files to somewhere else. --- ## [What is the use of Merge Row (diff)?](https://community.automationedge.com/t/what-is-the-use-of-merge-row-diff/17667)
**Author:** [@Apoorva\_25](https://community.automationedge.com/u/Apoorva_25)\ **Replies:** 1\ **Last updated:** [March 7, 2026, 10:34am UTC](https://community.automationedge.com/t/what-is-the-use-of-merge-row-diff/17667 "2026-03-07T10:34:21Z")
--- ## [What is use of multi way merge?](https://community.automationedge.com/t/what-is-use-of-multi-way-merge/17673)
**Author:** [@Apoorva1312](https://community.automationedge.com/u/Apoorva1312)\ **Replies:** 1\ **Last updated:** [March 7, 2026, 10:24am UTC](https://community.automationedge.com/t/what-is-use-of-multi-way-merge/17673 "2026-03-07T10:24:16Z")
--- ## [Row Normaliser](https://community.automationedge.com/t/row-normaliser/17493)
**Author:** [@Atharvavanarase](https://community.automationedge.com/u/Atharvavanarase)\ **Replies:** 1\ **Last updated:** [February 5, 2026, 5:23am UTC](https://community.automationedge.com/t/row-normaliser/17493 "2026-02-05T05:23:14Z")
In The Row Normaliser plugin in type columun what to set in that column? --- ## [Differenciate the workflow executer and process exceuter](https://community.automationedge.com/t/differenciate-the-workflow-executer-and-process-exceuter/17468)
**Author:** [@Anil\_Lokhande](https://community.automationedge.com/u/Anil_Lokhande)\ **Replies:** 1\ **Last updated:** [January 29, 2026, 3:29pm UTC](https://community.automationedge.com/t/differenciate-the-workflow-executer-and-process-exceuter/17468 "2026-01-29T15:29:47Z")
What is the difference between workflow executer and process exceuter? --- ## [Create Folder not working if Folder already exists](https://community.automationedge.com/t/create-folder-not-working-if-folder-already-exists/17465)
**Author:** [@ShreyasWaral](https://community.automationedge.com/u/ShreyasWaral)\ **Replies:** 1\ **Last updated:** [January 29, 2026, 1:47pm UTC](https://community.automationedge.com/t/create-folder-not-working-if-folder-already-exists/17465 "2026-01-29T13:47:34Z")
when i try to create folder with create folder plugin in process studio, it throws an error idk why? i was just trying to run my workflow and process once again to be double sure and now it throws an error. --- ## [Text File Output Plugin](https://community.automationedge.com/t/text-file-output-plugin/17322)
**Author:** [@omkar.shete](https://community.automationedge.com/u/omkar.shete)\ **Replies:** 2\ **Last updated:** [September 10, 2025, 7:01pm UTC](https://community.automationedge.com/t/text-file-output-plugin/17322 "2025-09-10T19:01:10Z")
I want to pass a filename from a variable. For this I have checked “Accept file names from a field” checkbox and given my field name which is coming out from Java script. But still it gives me error as fileName field can… --- ## [How to convert parameter into field value in calculator step](https://community.automationedge.com/t/how-to-convert-parameter-into-field-value-in-calculator-step/17018)
**Author:** [@sujeet24](https://community.automationedge.com/u/sujeet24)\ **Replies:** 1\ **Last updated:** [May 15, 2025, 12:28pm UTC](https://community.automationedge.com/t/how-to-convert-parameter-into-field-value-in-calculator-step/17018 "2025-05-15T12:28:17Z")
if you know about this issue then let me know or provide me the solution --- ## [Emmanuel Katto : Optimizing AutomationEdge Workflows for Large-Scale Data Processing: Seeking Advice and Best Practices](https://community.automationedge.com/t/emmanuel-katto-optimizing-automationedge-workflows-for-large-scale-data-processing-seeking-advice-and-best-practices/16593)
**Author:** [@emmanuelkatto23](https://community.automationedge.com/u/emmanuelkatto23)\ **Replies:** 0\ **Last updated:** [January 17, 2025, 11:22am UTC](https://community.automationedge.com/t/emmanuel-katto-optimizing-automationedge-workflows-for-large-scale-data-processing-seeking-advice-and-best-practices/16593 "2025-01-17T11:22:46Z")
Hello Everyone, I’m Emmanuel Katto, currently in the process of integrating AutomationEdge into my company’s system and, as a newcomer, I’m navigating some challenges. Specifically, we’re striving to optimize our data p… --- ## [Emmanuel Katto : Optimizing AutomationEdge Workflows for Large-Scale Data Processing: Seeking Advice and Best Practices](https://community.automationedge.com/t/emmanuel-katto-optimizing-automationedge-workflows-for-large-scale-data-processing-seeking-advice-and-best-practices/16591)
**Author:** [@emmanuelkatto23](https://community.automationedge.com/u/emmanuelkatto23)\ **Replies:** 0\ **Last updated:** [January 17, 2025, 11:21am UTC](https://community.automationedge.com/t/emmanuel-katto-optimizing-automationedge-workflows-for-large-scale-data-processing-seeking-advice-and-best-practices/16591 "2025-01-17T11:21:17Z")
Hello AutomationEdge Enthusiasts! :wave: :wave: I’m Emmanuel Katto, currently in the process of integrating AutomationEdge into my company’s system and, as a newcomer, I’m navigating some challenges. Specifically, we’re… --- ## [Web switch window handle](https://community.automationedge.com/t/web-switch-window-handle/13765)
**Author:** [@Deepak\_Y](https://community.automationedge.com/u/Deepak_Y)\ **Replies:** 0\ **Last updated:** [October 16, 2024, 7:27am UTC](https://community.automationedge.com/t/web-switch-window-handle/13765 "2024-10-16T07:27:02Z")
Hi, I m trying to switch to a new window generated from main window and used the web switch window plugin with the title, element and other options but it does not work, any alternative to handle multiple window please … --- ## [Dynamic Excel Input](https://community.automationedge.com/t/dynamic-excel-input/10454)
**Author:** [@NirmalVijay\_2228](https://community.automationedge.com/u/NirmalVijay_2228)\ **Replies:** 5\ **Last updated:** [May 16, 2024, 9:48am UTC](https://community.automationedge.com/t/dynamic-excel-input/10454 "2024-05-16T09:48:00Z")
Hi , I need to insert excel input dynamically from on folder and I am expected to receive output for each input file I send. Kindly help me out for this… --- ## [Microsoft Sheet - Increment/Add Sheet](https://community.automationedge.com/t/microsoft-sheet-increment-add-sheet/11758)
**Author:** [@fdc\_jpg](https://community.automationedge.com/u/fdc_jpg)\ **Replies:** 3\ **Last updated:** [March 19, 2024, 4:42am UTC](https://community.automationedge.com/t/microsoft-sheet-increment-add-sheet/11758 "2024-03-19T04:42:55Z")
Hello and Good day. I have this example scenario. For example, I am automating daily the stock’s price. Now, I want my Sheet1 to be named as the Stock Price value, so it will be named as “SP-031424”, I want it increment… --- ## [Getting the Sum/Total of Salary based on Job Role](https://community.automationedge.com/t/getting-the-sum-total-of-salary-based-on-job-role/11765)
**Author:** [@fdc\_jpg](https://community.automationedge.com/u/fdc_jpg)\ **Replies:** 2\ **Last updated:** [March 15, 2024, 5:46am UTC](https://community.automationedge.com/t/getting-the-sum-total-of-salary-based-on-job-role/11765 "2024-03-15T05:46:53Z")
Hello and Good day. I wanted to ask what is the right plugin or solution when trying to get the total/sum of a certain role. So, I have in my Excel File a Role that consists lots of roles and I want to get their tota… --- ## [Web set value](https://community.automationedge.com/t/web-set-value/11752)
**Author:** [@NirmalVijay\_2228](https://community.automationedge.com/u/NirmalVijay_2228)\ **Replies:** 1\ **Last updated:** [March 15, 2024, 4:03am UTC](https://community.automationedge.com/t/web-set-value/11752 "2024-03-15T04:03:48Z")
whenever I try to set the start date and end date ,it got disappeared after it set --- ## [Extracting data from dummy Rest API to Excel](https://community.automationedge.com/t/extracting-data-from-dummy-rest-api-to-excel/11737)
**Author:** [@fdc\_jpg](https://community.automationedge.com/u/fdc_jpg)\ **Replies:** 1\ **Last updated:** [March 13, 2024, 7:04am UTC](https://community.automationedge.com/t/extracting-data-from-dummy-rest-api-to-excel/11737 "2024-03-13T07:04:44Z")
Hello and Good day. I am trying to learn on how do I config and successfully execute the getting the data from a dummy REST API and write it down to an excel writer. So, as you can see in my workflow above, the rest … --- ## [Google won't sign in automated login account](https://community.automationedge.com/t/google-wont-sign-in-automated-login-account/11733)
**Author:** [@fdc\_jpg](https://community.automationedge.com/u/fdc_jpg)\ **Replies:** 3\ **Last updated:** [March 13, 2024, 12:43am UTC](https://community.automationedge.com/t/google-wont-sign-in-automated-login-account/11733 "2024-03-13T00:43:12Z")
Hello and Good day. As I have mentioned in the title I am just trying to practice to authenticate account using automation. However, google won’t let me login and it says this one in the image below, please refer to th… --- ## [Element can't be found when accessing the login form in the new tab](https://community.automationedge.com/t/element-cant-be-found-when-accessing-the-login-form-in-the-new-tab/11699)
**Author:** [@fdc\_jpg](https://community.automationedge.com/u/fdc_jpg)\ **Replies:** 3\ **Last updated:** [March 11, 2024, 2:54am UTC](https://community.automationedge.com/t/element-cant-be-found-when-accessing-the-login-form-in-the-new-tab/11699 "2024-03-11T02:54:09Z")
I am trying to automate login in various email provider. I have tried google, and now I am trying outlook. For reference. I will be attaching my Workflow here. Start Browser - Go To Microsoft Website Delay for a bit … [Next page](https://community.automationedge.com/tag/ps-steps/71.md?match_all_tags=true&page=1&tags%5B%5D=ps-steps)