Skip to Content
author's profile photo Former Member
Former Member

How to create a table using partial data from two row

Hello I have a table that has data from two sources but have same ID

ID A B C D 123 xyz xxy xxd xxa 123 abc abd def xxr

I want to create a table that uses partial data from both rows

123 xyz xxy def xxr

How can i Do this?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 18, 2015 at 08:05 PM


    it depends on how you want to get the valueas for the rows. In your example your getting , for A column, the value from the first row, but in column C, you´re getting from the second one.



    Add a comment
    10|10000 characters needed characters exceeded

    • Follow the above method, if you can get the data in two tables and you want the result set in one view.

      But what if you have only one table for both the sources(combined data). It is a kind of reverse engineering but for some reason if you have no control over the tables from the source, follow the below method (note, you will need to have a column "datasource" to check from where the data is coming)

      Create two alias tables (just one is enough but to keep the original table intact, create two) and insert a self join with filter on Datasource. Now drag and drop the objects that you want and you will get the desired results.

      2.jpg (36.6 kB)
      1.jpg (60.9 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.