Suppose there is a column with data type number.
The current “data scraping” data is first inserted using the “insert” activity, and then the character type is updated to a numeric type using “excute query”.
What I want to do is not use “insert activity” but process it within “excute query” at once.
hello calvin,
“update dayexrate_uipath
Set currency_id = Case
When currency_id = ‘USD’ then 1
When currency_id = ‘GBP’ then 2
When currency_id = ‘CAD’ then 3
When currency_id = ‘CHF’ then 4
When currency_id = ‘HKD’ then 8
When currency_id = ‘SEK’ then 9
When currency_id = ‘AUD’ then 10
When currency_id = ‘DKK’ then 11
When currency_id = ‘NOK’ then 14
When currency_id = ‘SAR’ then 16
When currency_id = ‘KWD’ then 17
When currency_id = ‘BHD’ then 18
When currency_id = ‘AED’ then 19
When currency_id = ‘JPY’ then 20
When currency_id = ‘EUR’ then 21
End
Where
currency_id In (‘USD’,‘GBP’,‘CAD’,‘CHF’,‘HKD’,‘SEK’,‘AUD’,‘DKK’,‘NOK’,‘SAR’,‘KWD’,‘BHD’,‘AED’,‘JPY’, ‘EUR’)”
Hi @S_Sim
If i right you re using datascraping to get values from the website and inserting into table .
Then What re u Updating in the table is based on your insert value from the datascraping
Need Clarification on that!
Regards
100% right
but
I’m using data scraping to get the value from the website and insert it into the table, but I’d like to update and insert without using “insert activity” here, is this possible?
Hi @S_Sim
Can you send me the screenshot of the Datatable using the OutPut datatable and Write line the Datatable as String ?
Output data table activity
Your Dt —>dt-rr
OutputStr—>StringVariable
writeline–>Strvariable
Regards
Regards
Hi @S_Sim
Please Refer to the xaml below I have created a skeleton for your case!
Update_Sequence.xaml (9.6 KB)
Hope the above helps!
Regards
really really thank you
Do you know how to use the data table dt_rr for “excute query”?
In “insert activity”, there is a separate “input datatable” property, but it does not exist in “excute query”, so how can I add data of datatable “dt_rr” in “excute query”?
your means,
data scrapping → for each row → insert ?
pravin_godvin
hi godvin,
With reference to the skeleton you gave us, we proceeded with “data scratching → exit query(select*) → for each row in data table → insert”, but it does not change(ex. USD → 1). Can you take a look?
In the switch statement, the existing CurrentRow (“current_id”).ToString.Equals(“USE”) Or CurrentRow(“currency_id”).ToString.Equals(“JPY”) … . … …
It’s not working. So,
CurrentRow(“currency_id”).Equals(“CAD”,“CHF”).ToString. I changed it like this. Is this a problem?
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu