Hi, I have issue with the pivot transform. I have a table with columns tablename,fieldname,constanvalue and another table with join tablename i did all the advanced setting like pivotkey of tablename =1, fieldname=2, and constantvalue=3. Changed all the lineageIDs but still it is throwing a duplicate pivot key value error. What am i missing in this? Thanks, Eshwar.

more information... I am getting an error ERROR: Duplicate pivot key value "BLD_Zone_Code" which is one of the values. I have two sets of flow one is 10 columns with transforamtions. and the other flow has the columns that i mentioned in the pivot transform. before pivot transform i have a merge join which merges these two flows.. do i need to set the pivotkeyvalue as 1 for the columns coming from the other flow? Thanks, Eshwar

more information... I am getting an error ERROR: Duplicate pivot key value "BLD_Zone_Code" which is one of the values. Thanks, Eshwar

Here's a good walkthough of the opaque Pivot. Talk to me now on