topic Re: Copying a table in QlikView

Copying a table

Mon, 13 Jun 2016 16:32:29 GMT

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;

Re: Copying a table

swuehl — Mon, 13 Jun 2016 16:36:09 GMT

Maybe

Qualify *;

MainTableCopy :

LOAD *

Resident MainTable;

Re: Copying a table

Digvijay_Singh — Mon, 13 Jun 2016 16:38:27 GMT

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.

Re: Copying a table

muthukumar77 — Mon, 13 Jun 2016 16:40:06 GMT

Hi,

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

Re: Copying a table

Mon, 13 Jun 2016 16:46:04 GMT

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

Re: Copying a table

swuehl — Mon, 13 Jun 2016 16:51:52 GMT

How to Rename Fields

Re: Copying a table

muthukumar77 — Mon, 13 Jun 2016 16:52:16 GMT

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;