Convert number of month to name of month in Excel

12 comments
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

10 comments
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?

2 comments
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...

How to skip Windows 7 login screen?

5 comments
If you have been running Windows 7 on your personal computer, chances are high that you haven’t assigned a password for your user account. Whenever you start your computer / laptop, the boot process will stop at the Login screen and you need to hit enter or click on your user account picture to see the desktop.

As you need to hit enter each time you start your your computer / laptop, here is quick solution to skip the Login screen.
  1. Click on Start and then enter the following command in the search box, then "netplwiz" and press the ENTER key. Or Open Run dialog box by using Windows + R keyboard shortcut and type "control userpasswords2" in Run dialog box and hit enter. This command will load the Advanced User Accounts Control Panel applet.
  2. Under User Accounts tab, uncheck the box named Users must enter a user name and password to use this computer.
  3. Click Apply button to see Automatically Log On dialog box. If you have a password for your user account, simply enter the password and click ok. If you don’t have a password for your account, simply click Ok.
  4. You are done. Reboot your Windows 7 to see the change.
Continue Reading...
> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger