Copying a table

[#1]

Hi All,

I want to copy a table in Qlikview, and not have it give me synthetic keys, don't want it to get linked to my other table as I will be doing different things with the main table, and I want my MainTableCopy to just be there separately. I'm having the below script to copy my MainTable, but it gives me synthetic keys.

NOCONCATENATE

MainTableCopy :

LOAD *

Resident MainTable;

[swuehl · Accepted solution]

Maybe

Qualify *;

MainTableCopy :

LOAD *

Resident MainTable;

[Digvijay_Singh]

If you just want separate table without any association, you can use Qualify *, at the top of your new load statement, it will create tablename.fieldname to keep them unassociated with similar field names.

[muthukumar77]

Hi,

You can use Qualify or change column name for that table.

[#5]

Great, this works thanks!

One question: Is it possible to change the field names when putting these fields in a table? because this changes the field names to Table_DataCopy.fieldname

[swuehl]

How to Rename Fields

[muthukumar77]

Yes,

Eg:

Load A,B,C from Main_Table;

you can do like this,

Load [Main_Table A],[Main_Table B],[Main_Table C] from Main_Table;