Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Consolidate Tables with Inconsistent/Different columns

Hi All,

 

I'm currently having a hard time consolidating my tables that is pulling from an SQL Database

I Pulled 5 tables and each of them have different columns/columns name (please screenshot below):

 

1. Request Table:

 

2. Answer Table:

 

3. Question Table:

 

4. Queue Table:

and lastly, Vote table:

 

So the desired output is to atleast consolidate them in one table.

Is this feasible? if no, are there any other ways to achieve similar results?

Thank you in advanced! 🙂

Need Help

1 Reply

  • zenisekd's avatar
    zenisekd
    Super User
    2 years ago

    Anonymous  Can you draw the logic of if? Either the tables you mention are incorrectly named (so it is not possible to conclude, which table links to another table) or there is no id column in common so there is no way to consolidate it.