How do I get a 2nd table columns on single row

Question

Hi,&nbsp;&nbsp; I have a table called "IssuesComponents" with 2 rows as follows (I calculate the Committed, Completed, Added, Removed based on the Item_Name value):&nbsp;Item_Name&nbsp; &nbsp;Key&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Committed&nbsp; &nbsp;Completed&nbsp; Added&nbsp; RemovedCommitted&nbsp; &nbsp;Data-123&nbsp; &nbsp;Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;N&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;N&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NCompleted&nbsp; &nbsp;Data-123&nbsp; &nbsp;N&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; N&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; N&nbsp;What I want is flatten this to a single row as follows:&nbsp;Key&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Committed&nbsp; &nbsp;Completed&nbsp; Added&nbsp; RemovedData-123&nbsp; &nbsp;Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;N&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; N&nbsp;&nbsp;Not sure how to do this ?&nbsp;

bhanu_gautam · Answer

EaglesTony&nbsp;, Can you please give us more details as on what basis data in committed and completed is "Y" in sample data shared from your end , what is the condition if any single row contains "Y" it will be "Y"?

eaglestony · Answer

I don't understand your question. This data is coming from a file outside which cannot be combined, thus why Ineed to combine into 1 row.. The Committed, Completed,Added,Removed are Conditional Columns based off the value in Item_Name

Forum Discussion

How do I get a 2nd table columns on single row

2 Replies

Related content

Autoexist in single column??

Retrieving Values from Single Column

Single-column dimension table

Single Selection of aggregated columns

refersh of Single table