topic Map to different table name and schema in Qlik Replicate

Map to different table name and schema

fj40wdh — Wed, 20 Mar 2024 13:15:42 GMT

Trying to map source table to a target with a different table name and structure in a different schema, same database. Basically trying to compile data from one table and write the data to another table based on a filter. Keep getting error that the task cannot create the source table in the target schema. I don't want to create the source table in the target schema

sourceschema.Sourcetable -----> targetscheam.targettable

srccol1 ----> tarcol1

srccol2 ----> tarcol2

srccol3 ----> tarcol3

different schema

different table name

different column names

Re: Map to different table name and schema

john_wang — Wed, 20 Mar 2024 13:27:15 GMT

Hello @fj40wdh ,

Thanks for reaching out to Qlik Community!

1. The basic steps of the schema name and table name mapping:

Tables settings --> General --> Input "Table Schema" and "Table Name":

2. The column name mapping

Tables settings --> Transform --> Output --> Name (overwrite the column name).

For example mapping column "notes" to "comments":

Certainly this in table level, the mapping takes action at this table only. You may define Global Rule to map the table name/schema name/column name/column type etc.

Hope this helps.

John.

Re: Map to different table name and schema

fj40wdh — Wed, 20 Mar 2024 14:29:15 GMT

Thanks, I had done that so I was confused. Turns out my table was suspended and that was causing other errors. Working now.

Re: Map to different table name and schema

john_wang — Wed, 20 Mar 2024 14:31:05 GMT

Glad to hear that, thank you so much for your support! @fj40wdh