Thursday April 27th 2017

Categories

Insider

Archives

‘Flat File Vrs RDMS’ Archives

Vlookup function in MS Excel Example

Vlookup function in MS Excel searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. In the example below we can find the taxrate based on income. Here income is 1,11,300 and tax rate is 45.25% because income is greater than 284701. Excel has it own very important role [...]

Flat file vrs RDBMS

A flat file is a file containing records that have no structured interrelationship. For example flat file is one in which table data is gathered in lines of ASCII text with the value from each table cell separated by a comma and each row represented with a new line. Another example of flat file can be an MS Excel spread sheet where each new row is [...]