Sure you can do it in a simple way: Create a new variable of type DataTable and set the name you want to have as a new name for the table Add an Assign activity Set the new variable on the left side On the right side you can add the current table you want to rename In this way, the new variable has the same content as the old one. This is a very simple way to rename the table. Another one will be using Invoke Code activity, where you do exact the same but inside the code.

This video already contains a use case for using an API in UiPath. Do you need something else? There is also another video about ChatGPT API in UiPath, which also another use case to learn more about using APIs in UiPath.

@@ActAutomate Thanks for the quick response! What I'm requesting is if you could please create more videos on how to use all the methods and how to get and update the orchestrator using the API. For example, if there are 20 queue items that are postponed, how can we clear those using the API? Something like this would be really helpful.

Certainly! It sounds like you're working with data tables and aiming to extract unique values from them. Whether you're using tools like **Power BI**, **Excel**, **SQL**, or programming languages like **Python (pandas)**, the general approach can vary slightly based on the platform. I'll provide a broad overview for handling this task using **two data tables** compared to using a **single data table**. ### **Scenario with a Single Data Table** When you have one data table and want to extract unique values, the process typically involves: 1. **Identifying the Column(s):** Determine which column(s) you want to retrieve unique values from. 2. **Applying a Distinct Operation:** - **Power BI (DAX):** Use the `DISTINCT` function. - **Power Query:** Use the "Remove Duplicates" feature. - **SQL:** Use `SELECT DISTINCT`. - **Python (pandas):** Use `df['column'].unique()` or `df['column'].drop_duplicates()`. *Example in Power BI DAX:* ```DAX UniqueValues = DISTINCT(Table1[ColumnName]) ``` ### **Scenario with Two Data Tables** When working with **two data tables**, you might want to extract unique values across both tables or based on some relationship between them. Here's how you can approach it: #### **1. **Appending/Combining the Tables** If both tables have the same structure and you want a combined list of unique values: - **Power BI (Power Query):** - **Append Queries:** Go to **Home > Append Queries** to stack the tables. - **Remove Duplicates:** After appending, select the column and choose "Remove Duplicates". - **SQL:** ```sql SELECT ColumnName FROM Table1 UNION SELECT ColumnName FROM Table2; ``` The `UNION` operation automatically removes duplicates. - **Python (pandas):** ```python combined = pd.concat([df1['ColumnName'], df2['ColumnName']]).unique() ``` #### **2. **Merging/Joining the Tables** If the tables are related and you want unique values based on a relationship: - **Power BI (DAX):** - **Relationships:** Ensure there's a relationship defined between the two tables. - **Using `UNION` in DAX:** ```DAX CombinedUnique = DISTINCT( UNION( SELECTCOLUMNS(Table1, "ColumnName", Table1[ColumnName]), SELECTCOLUMNS(Table2, "ColumnName", Table2[ColumnName]) ) ) ``` - **SQL:** ```sql SELECT DISTINCT T1.ColumnName FROM Table1 T1 JOIN Table2 T2 ON T1.Key = T2.Key ``` Adjust the `JOIN` type (INNER, LEFT, etc.) based on your specific requirements. - **Python (pandas):** ```python merged = pd.merge(df1, df2, on='KeyColumn') unique_values = merged['ColumnName'].unique() ``` #### **3. **Using Lookup Tables or Relationships** If you're referencing unique values from one table in another: - **Power BI:** - **Create a Relationship:** Define relationships in the model view. - **Use LOOKUPVALUE or RELATED:** To fetch unique values based on relationships. - **SQL:** Utilize foreign keys and join operations to fetch related unique values. ### **Practical Example in Power BI** Let's assume you have two tables: - **Sales 2022** - **Sales 2023** **Objective:** Get a unique list of Product IDs sold across both years. **Steps:** 1. **Append Queries:** - Go to **Home > Append Queries** in Power Query. - Select both **Sales 2022** and **Sales 2023**. 2. **Remove Duplicates:** - Select the **ProductID** column. - Click on **Remove Duplicates** in the ribbon. 3. **Load the Data:** - This will give you a single table with unique Product IDs from both years. **Alternative DAX Approach:** ```DAX UniqueProductIDs = DISTINCT( UNION( SELECTCOLUMNS('Sales 2022', "ProductID", 'Sales 2022'[ProductID]), SELECTCOLUMNS('Sales 2023', "ProductID", 'Sales 2023'[ProductID]) ) ) ``` This DAX formula creates a new table `UniqueProductIDs` containing distinct Product IDs from both sales tables. ### **Key Considerations** - **Data Consistency:** Ensure that the columns you’re combining have the same data types and formats to avoid errors. - **Performance:** For large datasets, operations like `UNION` and `JOIN` can be resource-intensive. Optimize your queries or consider indexing if using databases. - **Relationships:** Clearly define how your tables relate to each other to accurately extract and combine unique values. - **Tool-Specific Functions:** Each platform has its own set of functions and best practices. Familiarize yourself with the ones relevant to your tool (e.g., Power Query M functions vs. DAX functions in Power BI). ### **Conclusion** Extracting unique values from two data tables involves deciding whether to **combine** them first (through appending or merging) and then extracting unique values, or to extract unique values separately and then combine those results. The exact method depends on your specific requirements and the tools you're using. If you provide more details about your data setup or the tool you're using, I can offer a more tailored solution!

Thank you so much! I'm thrilled to hear that you enjoyed the tutorial. 😊 If you have any questions or need further assistance, feel free to reach out!

Thanks for your feedback, really happy to hear that :-)

This video is a general video about RegEx, but in many other videos we are using RegEx. To see all videos on the channel, you have to be a channel member, so that you can see the most important videos, especially the LINQ videos (about 70 videos from A to Z)

within a month we will start posting new videos each week, not only RPA, but also AI. We are preparing the videos and the topics. In case you have any topics you want to see here, please write us back

@@ActAutomate that's a great news and thanks for responding my comment.. I have a request to continue with the Short video series of UiPath which is very impactful in learning, please also focus on that part... And also cover how to Convert REFrame work to work with Linear transactions and in a short video so we can add changes or prepare for interviews. Thanks in advance

Hi Sameer, you have to join the channel (you have to be a channel member), so that you can access all LINQ videos. We will be very happy to have you on our channel. In case you have any questions, please don't hesitate to write us back.

@@ActAutomate Do we really have any future growth as a RPA Developer. I'm totally clueless with RPA, because currently I'm getting hardly 20 to 30 % hike. Is it good to continue the RPA or shall I change the domain? Could you please suggest anything?

@@sameerkumarsahu5164 Stick with the organisation you are in. With years of work experience earn certificates & knowledge over time along with work. Create more dependencies on pars of RPA like database, cloud, orchestrator, etc. With this much of foundation along with work exp in same organisation you can demand a 100% hike and they won't be denying you. Also, do love to automate !

what rpa do you use to import javascript?

We are working on the new videos, which will be more advanced. Currently we are working on our new concept, therefore we don't upload new videos. Please keep following us and wait for the next generation of our videos, which will help you a lot in your career.

Thanks for your comment. The videos are now only for channel members. If you want to watch the videos, you have to be a member. Here is the link: kzbin.info/door/gmw5KA88D6jS8lPBzEXFgAjoin You also have another option to check the videos. You can also join our course on Teachable. There we not only have the LINQ videos, but also more videos about UiPath in general, which are very helpful for any UiPath developer, but also for anyone who wants to learn LINQ in very details, from A to Z. Here is the link to the course: actautomate.teachable.com/p/mastering-linq-in-uipath-with-vb-net-from-zero-to-hero