Hi Masters,
I am having the same issue,
I am using one Flat file source and other is Excel source, want to merge one more column which is in Excel file, and in both of the sources Account_Id column are same,
Although both were using diff Data type but UI used Data Conversion and make them same,
Also used Sort on both of the sources on Account_Id column.
but still I am getting the Lineage Id issue.that I am using the Lineage Id which is not previously used.
Can you please suggest me that how you solved this problem, would be really Appreciate.
Thanks in Advance.