What is Python?

Python was created by Guido van Rossum, and released in 1991. 

Python is a popular programming language. It is an interpreted, interactive, object-oriented programming language. It incorporates modules, exceptions, dynamic typing, very high level dynamic data types, and classes. It supports multiple programming paradigms beyond object-oriented programming, such as procedural and functional programming. Python combines remarkable power with very clear syntax. It has interfaces to many system calls and libraries, as well as to various window systems, and is extensible in C or C++. It is also usable as an extension language for applications that need a programmable interface. Finally, Python is portable: it runs on many Unix variants including Linux and macOS, and on Windows 

It is used for: 

• web development (server-side), 
• software development, 
• mathematics, 
• system scripting.

Continue Reading...

Convert number of month to name of month in Excel

Lets assume Date in A1 cell then use the follwing formulas

• =TEXT(A1,”MMMMM”)
  for the first letter of the month
• =TEXT(A1,”MMMM”)
  for the month spelled out completely
• =TEXT(A1,”MMM”)
  for the 3 letter abbreviation of month

Continue Reading...

Informatica Scenario 1

We have a source table as follows:

We have to move the into the target tables such that one

MY SOURCE		MY TARGET
SNo Name 1 A 2 B 1 C 3 D 4 F 1 E 2 G		SNo Name 1 A 2 B 1 C 3 D 4 F 1 E 2 G

After importing Source and Target, create a Sorter transformation to sort the data.
Then create an Expression transformation with 3 ports named say v_Name, v_SNo (2 variable ports) and o_Name (output port).
Give an expression as follows
v_Name -> IIF(SNo = v_SNo, v_Name||Name, Name)
v_SNO -> SNo
o_Name -> v_Name
Finally connect the ports to Target, create and execute the session and workflow.

Continue Reading...

How to Copy and Paste values without Formulas in Excel?

In Microsoft Excel, when you perform a normal copy and paste on a cell that has been calculated by a formula, the formula gets pasted as well. Sometimes, when you copy the contents of a cell, you want to paste just the value and not the underlying formula that is displayed in the formula bar like copy the resulting value of a formula to a cell on another worksheet. You can get an invalid cell reference error (#REF!) error.

You can avoid this error by pasting the resulting values of formulas without the formula in destination cells.

1. Select the cells or ranges you wish to copy.
2. On the Home tab, under Clipboard, select Copy.
3. Select the cell you wish to paste your values to.
4. Click the lower half of the large Paste button; from the extended menu that appears, select Values. Then click OK.

Or use a Shortcut Menu

1. An even quicker way to paste values is by using a mouse shortcut:
2. Point to the border of the selected range, and the pointer should change to a four-headed arrow.
3. Press the right mouse button, and drag the cells slightly to the right.
4. Keep pressing the right mouse button, and drag the cells back to their original location.
5. Release the right mouse button and a shortcut menu will appear.
6. Click on Copy Here as Values Only.
7. The formulas are replaced by the values of their results.

Continue Reading...