You want to add a separate sysdate column when using 'data scraping' to send data to db using 'insert activity'. Is there a way?

:wink:
insert → excute query(insert sysdate)
half success
but,

image
why not together

Hi @S_Sim

If you want to insert systemdate in database means.

write insert query as below.

insert into your_table_name('DateColumn','otherColumns') values ('"+Now.Tostring(dd-MM-yyyy")+"','"+row("yourColumnName/Column index")+"');```

Regards

hi calvin,
I know how to query.
Used within ‘excute query activity’ and put into datable such as ‘insert activity’, but failed to operate.

@S_Sim

Can you share me your screenshot of your workflow?

Regards

1 Like

image
tts ~ cab column = data scrapping
currency_id, currency_date = column I’m going to insert separately

Hi @S_Sim

I think you need to use update query here !

If the data has inserted already you need use update query.

Regards

1 Like

ah ha i try update
thank you calvin :slight_smile:

fast solution

@S_Sim

Thank you !

Happy Automation!

1 Like

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