System Access Column lineage showing inaccurate results

[Mahesh_Yadav]

Hi All,

I have been trying to leverage the system column lineage table to check the overall journey of a column. But i am getting inaccurate results wherever unpivot transformations are used.

Instead of showing the results in a way that 20 columns are used to build a single column, lineage is showing that any one source col used in group by is generating all the cols that doesn't make any sense.

On using AI assistant i am getting below for the same. 

Can anyone please guide for any solution for this inconsistency?

[Kaniz_Fatma]

Hi @Mahesh_Yadav, 

• Unpivot transformations can reshape data by converting columns into rows. If you’re seeing unexpected results, double-check the unpivot logic you’re using. Ensure that it aligns with your intended transformation.
• In Power Query, for example, you can select specific columns to unpivot. Make sure you’re unpivoting the right columns.

1.