topic Re: [Qlik Compose] How to change target table name? in Qlik Compose

[Qlik Compose] How to change target table name?

iti-attunity-sup — Fri, 14 Mar 2025 20:49:07 GMT

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.

Re: [Qlik Compose] How to change target table name?

sureshkumar — Tue, 13 Aug 2024 07:44:18 GMT

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

Re: [Qlik Compose] How to change target table name?

iti-attunity-sup — Mon, 19 Aug 2024 01:29:18 GMT

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.

Re: [Qlik Compose] How to change target table name?

sureshkumar — Mon, 19 Aug 2024 04:51:09 GMT

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

Re: [Qlik Compose] How to change target table name?

iti-attunity-sup — Tue, 20 Aug 2024 02:30:53 GMT

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.

Re: [Qlik Compose] How to change target table name?

sureshkumar — Thu, 22 Aug 2024 11:02:50 GMT

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