DATABASE _ CREATE Create a new database Write the correct SQL statement to create a new database called testDB. CREATE DATABASE testDB; Delete a database Write the correct SQL statement to delete a database named testDB. DROP DATABASE testDB; Create a new table Write the correct SQL statement to create a new table called…
SQL Grammer _ BASIC SELECT – extracts data from a database UPDATE – updates data in a database DELETE – deletes data from a database INSERT INTO – inserts new data into a database CREATE DATABASE – creates a new database ALTER DATABASE – modifies a database CREATE TABLE – creates a new table ALTER TABLE – modifies a table DROP TABLE – deletes…
EXCEL FUNCTIONS_Basic AND Returns “TRUE” or “FALSE” based on two or more conditions. =AND(B2=”Fire”;C2>70) =IF(AND(B10=”Fire”;C10>70);”Yes”;”No”) AVERAGE Calculates the average =AVERAGE(B2:E2) AVERAGEIF Calculates the average of a range based on a true or false condition. =AVERAGEIF(range, criteria, [average_range]) AVERAGEIFS The average of a range based on one or more true or false condition. =AVERAGEIFS(average_range, criteria_range1, criteria1, …) CONCAT To link something together. =CONCAT(A2,” “,A3) =CONCAT(A2,”and”,A3) …
String Class with Uipath [String] String.Concat (VarName1, VarName2) : Concatenate the string representations of two objects [Boolean] VarName.Contains(“Text”) : Whether the string contains [String] String.Format(“{0} is {1}”, VarName1, VarName2) : Convert the object value to a string and insert it into other text. [Int32] VarName1.IndexOf(“a”) : Returns the index (starting from 0) of the…
Excel, Data Table with Uipath Excel Application Scope Used for working with the specified Excel file Making Data Table Activities Build Data Table Read Range Read CSV Data Scraping (Web) Generate Data Table (Text) Editing Data Table Activities Add Data Column Add Data Row Clear Data Table Filter Data Table For Each…
I/O Activities with UiPath Use Application/Browser The activity is a latest activity replacing the following activities. Open Application Open Browser Attach Window Attach Browser Element Scope Close Window Start Process The latest activity choose the best option among the Selector, Fuzzy Selector or Image as a targeting method. For the classic activities, the general option…
RPA_Client Wants Today’s ticket ranking list 1. Email Using categories from the client’s email Current the categories that the client wants: 전체, 스포츠, 콘서트, 뮤지컬, 캠핑 There might be no category on the website. In this case, need Exception Sending the end data with Excel to the client by email. 2. Robotic Enterprise Framework Exception…
1. RPA, How to use a variable with assign activity 1) string Making the File Path with string variable and assign activity Value to Save : “folder_email\price_temp.xlsx” “folder_email\price_result.xlsx” 2) array 3) List Initialize a list variable 4) Datatable Initialize a datatable variable 2. How to use two more variables with FOR activity 1) String and…
Completion time : 37h 25m I couldn’t find the course in English. After I complied this course, I got the Diploma of completion Subject (Total 21) UiPath Platform 알아보기 Studio로 첫 번째 프로세스 빌드 RPA Developer의 하루 Studio의 변수 및 인수 Studio의 컨트롤 흐름 Studio를 사용한 UI 자동화 (사용자 인터페이스 자동화 소개, 최신 환경의 …