Issue with pivot transform
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.
March 24th, 2011 1:50am