Icon

Ch2_​Workflow_​Examples

Reading data from files Reading data from databases Filtering This workflow contains examples of data access from file and from database, data conversion, data transformation, and datavisualization. Aggregations Data Transformations SentimentAnalysis.tableSentimentRating.csvProductData2.xlsConnect toWebActivity.sqliteDemographics.csvWebdataOldSystem.csvtableweb_activityimportNode 15on SentimentAnalysisremove record 11177Exclude Customerkey 11177First(WebActivity)CustomerKeyremove record 11177records to removeonly menCustomerKeywomen vs. mencount andavg(age)lowercase(Gender)* ROWCOUNTback from avglowercase(Gender)lowercase(MaritalStatus)on CustomerKeyon CustomerKeyon CustomerKeywomen vs. menmarried vs. singlecountreplace(Gender, "M", "Male")replace(Gender, "F", "Female")Table Reader File Reader Excel Reader (XLS) SQLite Connector File Reader File Reader DB Table Selector DB Reader Concatenate Column Filter Joiner Row Filter DB Row Filter Column Rename Number To String ReferenceRow Filter Table Creator Row Filter String To Number GroupBy String Manipulation Math Formula(Multi Column) Math Formula String Manipulation(Multi Column) Joiner Joiner Joiner Pivoting String Manipulation String Manipulation Reading data from files Reading data from databases Filtering This workflow contains examples of data access from file and from database, data conversion, data transformation, and datavisualization. Aggregations Data Transformations SentimentAnalysis.tableSentimentRating.csvProductData2.xlsConnect toWebActivity.sqliteDemographics.csvWebdataOldSystem.csvtableweb_activityimportNode 15on SentimentAnalysisremove record 11177Exclude Customerkey 11177First(WebActivity)CustomerKeyremove record 11177records to removeonly menCustomerKeywomen vs. mencount andavg(age)lowercase(Gender)* ROWCOUNTback from avglowercase(Gender)lowercase(MaritalStatus)on CustomerKeyon CustomerKeyon CustomerKeywomen vs. menmarried vs. singlecountreplace(Gender, "M", "Male")replace(Gender, "F", "Female")Table Reader File Reader Excel Reader (XLS) SQLite Connector File Reader File Reader DB Table Selector DB Reader Concatenate Column Filter Joiner Row Filter DB Row Filter Column Rename Number To String ReferenceRow Filter Table Creator Row Filter String To Number GroupBy String Manipulation Math Formula(Multi Column) Math Formula String Manipulation(Multi Column) Joiner Joiner Joiner Pivoting String Manipulation String Manipulation

Nodes

Extensions

Links