Map to different table name and schema

[fj40wdh]

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

[john_wang · Accepted solution]

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.

[fj40wdh · Accepted solution]

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

[john_wang]

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