Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: alexle
  • Content: Threads
  • Order by date
  1. alexle

    Swapping Rows and Columns

    Is there any trick for swapping rows and columns of a XLS datasource in Informatica? In other words, I have an XLS files that are row format and would like to turn those rows into Column Format using Informatica. Original Format # ProgID Desc ParentID 1 1000 TopLevel...
  2. alexle

    Reset CUME() value when new encounter new key

    I'm using CUME() function in my expression to do calculate a running-total. However, the CUME function doesn't reset the value when a new key (program name in my case) is encountered. The CUME() sums all the rows from top to bottom as one single category. I would like to know if there is a...

Part and Inventory Search

Back
Top