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...
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 mont...
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,...
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...
Subscribe to:
Posts
(
Atom
)
>
