I want to insert data scraped data and current date, current_id column into one table

Help Activities
, ,
1

image
image813×527 34.8 KB

How should I add it to the xml editor?
The current date, current_id column is a separate column that does not exist in data scraping.

2

Hi @S_Sim,

You can’t add your customized data into scraping xml.
But you can do it in 2 ways.

  1. scrap the data and save it into table. Then in each loop you can add your customized column.
  2. Before scraping Build a datatable and add all your columns. For the columns you can set default value. Saved the scarped data and give the names to the columns matching with your datatable columns.

Thanks,
Manjula

1 Like
3

I’ll try the second one and get back to you. thank you

4

use ‘build data table’ and write all column right?

5

Yes, Build DataTable with all the columns. Its like predefined coulmns, then your are adding values to those columns.

6

this right?

  1. open browser
  2. build data table
  3. Data Scrapping Extract Structured Data (output datatable = dt_rr)
  4. Connect
  5. Excute Query ( Output Datatable = dt_rr)
  6. insert ( input Datatable = dt_rr)
    …understand?
7

I would start from Build Data Table.

  1. Build DataTable (name dt_rr)
  2. Open Browser
  3. DataScapping (Output dt_rr)
1 Like
8

next,

  1. connect
  2. Excute Query ( “insert into table (currency_date, currency_id) VALUES(to_date(sysdate,‘dd.mm.yyyy hh24:mi’),‘1’)”
    (current_date, current_id = pk)
  3. insert (input dt_rr)

==

image
image595×502 15.1 KB

check connection clear

humm What’s wrong

9

The value should added each row. You are trying to add to table that’s many be the cause. Do it on each row loop.

1 Like
10

sorry i dont understand

11

Hi,

Insert query is going to apply for each row right. Then you have to do it in For Each Row loop.

your data is saved in dt_rr. Now open For Each Row loop and inside the loop apply insert query.

Here i attached the sample workflow. See it if it help you.

ForumSim.xaml (13.0 KB)

Thanks,
Manjula

12

Thank you but, your file doesn’t work in my uipath exe… ㅠㅠ
However, in ‘excute query activity’, the update statement is used to resolve it.
image
complete this problem

13

You mean to say the issue is resolved or still have problem.

Sorry i didn’t understand your previous reply.

1 Like
14

complete

1 Like
15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.