Join DataTable in Automation Anywhere |Merge DataTable |Remove Duplicate Rows| Sort | Insert Row-#27

[@qualityassurancelab7764]

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!

[@niharzutshi9662]

Thanks 🧡

[@badasskiller9156]

I need one help ,I am facing problems extract data from I frame web application

[@badasskiller9156]

Please help me how to extract data in I frame application

[@HeyTCT]

This is the video I was waiting for! Thank you so much for uploading this. One issue I found was I can't directly perform table operations on captured webtables. I have to store it in excel first.

[@sahitidasara9425]

Yes, operating on a webtable takes time in A2019. Instead in A11 it is possible. In that case an action named v11 Task bot is available so you can use that.

[@navedansari7778]

Hi, I have created two Table variables under get multiple cells for two excel sheets. But when I am doing Remove duplicate rows step and selecting Data table name to the variables I have created, it is giving error: variable not found (6:53) . Can you please help where I am doing wrong.

[@qualityassurancelab7764]

Hi, seems like you are following the correct approach. Is your data table variable listed under the variables list?

[@arnavv_SRJ]

Thanks Mam.its very usefull to us .thank you

[@mteja4010]

What If my table1 and table2 has multiple same columns. And table3 , I want updated column?

[@4_Haters]

what if the systme unable to find the excel file when apllying to write to file action ?

[@ajithcs4321]

Thanks mam for the video ..

[@koizumichiaki]

Hi, i trying to insert row into null data table, may i know how to insert value dynamically inside loop?

[@qualityassurancelab7764]

Hi, First create a table variable, then add loop action with your loop condition. Inside loop action, add Insert row action.

[@sandeepuniyal6817]

if we want to merge more than 2 csv or excel files how can we do it?

[@claudiatapia8453]

Thank you for your videos. I did the example, but it is not working correctly. I get the right rows but it shows duplicate columns, Employee is repeating twice. I tried using Data Table. I created 2 data tables(manually) and the result is the same, Employee is repeating twice, after writing to file and before writing to file (checking using message). I am not sure if data table join has a bug. I did the example using all joins (left, inner, etc.) and the problem is the same. Note: I selected the same column to join, the same as your video

[@qualityassurancelab7764]

You're welcome. It seems like you are doing correct, could you pls share the screenshot of the join action at [e-mail]?

[@neenusb2370]

hi, can we do it on excel advances package?

[@Food_food_food27]

Can you please tell me how to swap columns in excel ?

[@kishoredummanaboyina5779]

Hi Admin sir I need ( how to calculate the no of repatative duplicate data in the excel column and send it through mail😮)

[@vamsikrishnamekala9317]

What if there are empty rows. How to delete empty rows???

[@MG-vb6ms]

Hi, thank u for the excellent video. For insert row operation I am getting the error as The schema size of the row to be entered is different from the table. Please check whether the schema is same. If the problem persists, please contact your System Administrator.

[@qualityassurancelab7764]

Hi, could you please confirm you have taken similar fields/columns in both table and record (row which you are trying to add in the table)?

[@kuantt]

this is very good video. I would like to check with you how to copy merge data table (table 1+2) to be the same type in table 3. I am having problem when data type column 2(table 2) is numeric....if i use different read option...i will have different result. let me know your thought. Thanks, kuan

[@madhavathokala7481]

Can you please make a video on A2019 Coding Stanlndards

[@syed_sameer_ul_islam]

mam waiting for u r videos