Solved: How to load all columns while residint load - Qlik Community

Report Inappropriate Content · ‎2014-09-15

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

MarcoWedel · ‎2014-09-15

newTableName:

Load *

Resident oldTableName;

Drop Fields unwantedField1, unwantedField2 From newTableName;

View solution in original post

PrashantSangle · ‎2014-09-15

Hi,

Use

Load *

Resident oldTableName;

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

MarcoWedel · ‎2014-09-15

newTableName:

Load *

Resident oldTableName;

Drop Fields unwantedField1, unwantedField2 From newTableName;