CODEWITHSUNDEEP
informaticainformatica-powercenter
Ragav
Ragav

Reputation: 229

convert rows into Column informatica

could you please let me know how to transform the rows into Column in powerCenter? attached the Snapshot below.

enter image description here

Upvotes: 1

Views: 6228

Answers (1)

Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17383

All you need is an aggregator - group by Product and add two output ports to calculate the product value:

  • Current_value - MAX(IIF(end date = 1231999, Value, NULL))
  • Future_value - MAX(IIF(end date = 01010001, Value, NULL))

UPDATE:

PowerCenter aggregate functions take an optional filter_condition parameter, so you can also use the equivalent, more concise syntax:

  • Current_value - FIRST(Value, end date = 1231999)
  • Future_value - FIRST(Value, end date = 01010001)

Upvotes: 3

Related Questions