Issue while Resident Original Table

[#1]

Dear QV Experts,

While i resident the original table, i could see TableName.ColumnName in the Resident Table.

Facing discrepancies while associating the tables.

Are there any settings in QlikView or How to get rid of this?

Can you please suggest me

Thanks,

Sasi

The screenshot enclosed.

[ajsjoshua]

Hi sasi,

share ur script.

[CELAMBARASAN · Accepted solution]

Check whether you have used below statement anywhere before the script.

Qualify *;

If it is needed there and not needed after some places to remove that use below statement

UnQualify *;

[nagarjuna_kotha]

Hi Sasi,

Can share ur script ?

Where ur using resident on origirinal table ?

-Nagarjun

[nagarjuna_kotha]

Need to check :

• Check Drop Table statement of that table
• Check Table while taking resident..
• Check Exit Script

-Nagarjuna

[#6]

Thanks Everyone. It is my mistake. i need to unquality those columns. There was an Qualify *; which i didnt noticed.

Thanks.

[#7]

Hi,

if you got the solution  close this thread by making one post as correct.

regards

tripati