[Qlik Compose] How to change target table name?

[iti-attunity-sup]

Hello support team.

Is is possible to change Data warehouse (target) table name ?

Is it possible to use already created table as target ?

Best Regards. 

[sureshkumar]

Hello @iti-attunity-sup 

change target table name?

--> Do you mean "Data Warehouse Database", if then we can change the DB.

And also, could you please elaborate on "use already created table as target ?

Regards,
Suresh

[iti-attunity-sup]

Hello Suresh.
Thank you for your reply.

>Do you mean "Data Warehouse Database", if then we can change the DB.

No, I'd like to change table name in Data Warehouse.

>And also, could you please elaborate on "use already created table as target ?

Is it possible to use table like created by other project or created manually as Data warehouse table (target)?

Best Regards.

[sureshkumar]

Hello @iti-attunity-sup 

Could you provide us the screenshot of what you are referring so that we can suggest correctly.

OR please submit a support ticket to analyze further.

Regards,

Suresh

[iti-attunity-sup]

Hello Suresh.

Thank you for you reply.

Our goal is to load from multiple source tables to single target table(DWH table).
And I'd like to realize this by creating some mappings.

So I'd like to know how to change target table name and use already created table as target.

Best Regards.

[sureshkumar · Accepted solution]

Hello @iti-attunity-sup 

You need to create a table in the Model from scratch which will have the correct metadata which includes the columns from all the source tables you have.

Once you have that table, you can use several mappings for the same DWH table you've created, each mapping will use a different source table with the columns you need.

For example Assume you've Table A and Table B from different sources, Table A - col1,col2 and col3 and Table B- col3,col4 and col5 then you can create, table C in the Compose project model manually, with col1...col6
once you have that table in the model, you create 2 mappings, one from Table A which will contain only col1..col3, and another mappings from Table B which will contain col4...col6

Note: Both Table A and Table B should use the same primary key

Regards,

Suresh