Sorting of Student Marks & Loading in Database


- Prepare excel file 


- File > New > Transformation
- Press Design tab in palette
- Drag Input > Excel Input, Output > Table output, Transform > Sort Rows Steps onto workspace

- Dbl click Excel Input

- Browse for the excel file you want to provide as an input
- Press Add Button
- In Sheets tab select the sheet using "Get sheetnames" & select the sheet containing data
- Select fields tab press "get fields from header row" to fetch all the fields from the selected sheet
- press ok to close the window

- Connect the all the steps by creating a hop between the steps using Shift + Drag from one step to another

- Select the Sort rows step
- select the field name from the dropdown list by clicking a cell of the table which appears
- Select the order as Ascending > N as we want to sort the rows in descending order

- Click ok to close the window


- dbl click table output
- In connection input the connection you want by creating a new one or using existing.
- Lets say we want to create a new connection to Sql server See fig for example of the fields to fill up
- test the connection by clicking on test button

- Press OK to close the window
- in the target table input put the Table name you wat to use as te output or write a name to create a new one
- Click the sql button to generate a sql statement to create the table in the schema you have specified beforehand. Click Execute Click Close

- select the database fields mapping tab to select the fields of the stream & db fields for mapping, Click ok

- Click ok

- Save & run

Comments

Post a Comment

Popular posts from this blog

Increase Java Memory For Pentaho Data Integration

Pentaho runs inside a Java virtual machine, and hence is bound by the properties of that VM. These optimisations can apply to just about any Java application, including the Pentaho BI Server and GUI tools. Method to increase memory allocation: Open the file spoon.sh or spoon.bat in a text editor Look for a section that looks like this: # ****************************************************************** # ** Set java runtime options                                     ** # ** Change 256m to higher values in case you run out of memory.  ** # ****************************************************************** OPT="-Xmx256m -cp $CLASSPATH -Djava.library.path=$LIBPATH -DKETTLE_HOME=$KETTLE_HOME -DKETTLE_REPOSITORY=$KETTLE_REPOSITORY -DKETTLE_USER=$KETTLE_USER -DKETTLE_PASSWORD=$KETTLE_PASSWORD -DKETTLE_PLUGIN_PACKAGES=$KETTLE_PLUGIN_PACKAGES" Change the -Xmx parameter to alter the max...
Read more

Null pointer exception in tmap

You might have faced a common error in Talend i.e. the  NullPointerException in tMap "Exception in component tMap_1 java.lang.NullPointerException" Solutions: 1) Make sure your columns are nullable when you define the schema. 2) The NullPointerException indicate there are some null value on lookup table, so you need to deal with the null value on corresponding columns on expression filed of tmap, for example: !Relational.ISNULL(row13.abc)? row13.xyz:row13.sss:null
Read more

Different Match Models in tMap with example

Unique Match:     (Also called Last match) If several matches are found in the Inner Join, i.e. the last row matching the explicit join as well as the filter will be added to the output flow. First Match: If several matches are found in the Inner Join, i.e. the first row matching the explicit join as well as the filter will be added to the output flow. All Match: If several matches are found in the Inner Join, i.e. rows matching the explicit join as well as the filter, all of them will be added to the output flow Example: deptid   sales 1           1000 2           2000 3           3000 2           5000 3           6000 Outputs: 1. Unique match deptid   sales 1           1000 2           5000 3           6000 2. All matches deptid  ...
Read more