topic Re: How to load all columns while residint load in QlikView

How to load all columns while residint load

Mon, 15 Sep 2014 13:01:08 GMT

Hi friends

I have a table. I want all the coumns expect two in to new table. Is there any way to get all the coumns into next table without typing all the column names again.

Thanks

Pavan

Re: How to load all columns while residint load

PrashantSangle — Mon, 15 Sep 2014 13:02:59 GMT

Hi,

Use

Load *

Resident oldTableName;

Regards

Re: How to load all columns while residint load

MarcoWedel — Mon, 15 Sep 2014 13:05:13 GMT

newTableName:

Load *

Resident oldTableName;

Drop Fields unwantedField1, unwantedField2 From newTableName;