Excel and DataTables : Practice 1 - Working with DataTables

출처 : UiPath Academy

Practice 1 - Working with DataTables

두 개의 DataTable을 만들어 세 번째 DataTable로 결합하고, 불필요한 열을 후자에서 제거하고 항목을 정렬한다.

 

Practice 1 - Working with DataTables

Build Data Table : user

Build Data Table : overdueBooks

Join Data Table

1.1 Contact the overdue book borrowers (Sequence)			
	Private = False		
	Variables		
		users(DataTable)	
		overdueBooks(DataTable)	
		borrowedBooks(DataTable)	
		borrowedBooksString(String)	
	Activities		
		1.36 Build Data Table Users (BuildDataTable)	
			DataTable = users
			Private = False
		1.33 Build Data Table overdueBooks (BuildDataTable)	
			DataTable = overdueBooks
			Private = False
		1.24 Join Data Tables (JoinDataTables)	
			DataTable1 = overdueBooks
			DataTable2 = users
			JoinType = Inner
			DataTable = borrowedBooks
			Private = False
		1.29 Remove duplicate ID column (RemoveDataColumn)	
			DataTable = borrowedBooks
			ColumnIndex = 6
			Private = False
		1.16 Remove Department column (RemoveDataColumn)	
			DataTable = borrowedBooks
			ColumnName = Department
			Private = False
		1.10 Sort Data Table (SortDataTable)	
			DataTable = borrowedBooks
			Name = ID
			Order = Ascending
			DataTable = borrowedBooks
			Private = False
		1.5 Output borrowedBooks to text (OutputDataTable)	
			Text = borrowedBooksString
			DataTable = borrowedBooks
			Private = False
		1.2 Write Line (WriteLine)	
			Text = borrowedBooksString
			Private = False

OUTPUT

DataTablesDemo11 execution started
BookTitle,Author,BookID,ID,LastName,FirstName,Phone
Disgrace,"Coetzee, J.M.",989120,111200,Sakir,Duane,5551098
A Brief History of Time,"Hawking, Stephen",161700,145443,Porter,Dean,5559876
Cosmos,"Sagan, Carl",285454,145443,Porter,Dean,5559876
It,"King, Stephen",832127,201485,Fredericks,Denise,5553210
The Road,"McCarthy, Cormac",890437,201485,Fredericks,Denise,5553210
Midnight Children,"Rushdie, Salman",873102,287556,Calmoore,Georgia,5555432
Corrections,"Franzen, Jonathan",974320,287556,Calmoore,Georgia,5555432
DataTablesDemo11 execution ended in: 00:00:02