SQL Transformation

[Former Member]

Hi All,

I have a query and which ran successfully in my database  but when I copied the same into the SQL transform , its showing the following error.

The SQL  statements generates the following duplicate columns: BODI-11301.

I have a few select in select SQL statements.

Thanks.

[Former Member · Accepted solution]

Is there a column name repeated? I mean same name multiple times?

[Former Member · Accepted solution]

Yes it is , in the join condition.

[Former Member · Accepted solution]

I am asking about the output. When you run in SQL Server did you find any duplicate columns in the output?

[Former Member · Accepted solution]

Yes, many columns.

[Former Member · Accepted solution]

Why do you have duplicate columns? DS will not take multiple columns with same name. You need to change the column names to unique.

[Former Member · Accepted solution]

Just now , I removed the duplicate columns with same name:

I have  issue with this select statements:

(select A.Parent_WO_NUM from A where A.WO_NUM = B.wo_NUM and
A.WO_line = B.wo_Line) as "ParentWO",
(select A.Parent_WO_LINE from A where A.WO_NUM = B.wo_NUM and
A.WO_line = B.wo_Line ) as "ParentWOLINE",
(select S.SO from S where (select A.Parent_WO_NUM from A where A.WO_NUM = B.wo_NUM and
A.WO_line = B.wo_Line) = S.wo_num) as "SO",
(select S.SO_LINE from S where (select A.Parent_WO_NUM from A where A.WO_NUM = B.wo_NUM and

A.WO_line = B.wo_Line) = S.wo_num) as "SO_LINE",

[Former Member · Accepted solution]

This could be easily done by joining three tables A,B and S than doing multiple select in SQL transform.

Whats the exact error you are getting?

[Former Member · Accepted solution]

Thank you found it .

Thanks.