Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

How to drop SALES_TABLE-1 ?

Hi All

My Table model :-

HOW TO DELETE TARGET TABLE.png

I using below load script to drop SALES_TABLE-1  :-

CONCATENATE(SALES_TABLE)
LOAD * Resident "SALES_TABLE-1";
Drop Table "SALES_TABLE-1";

I get below error msg :-

Table not found
CONCATENATE(SALES_TABLE)
LOAD * Resident "SALES_TABLE-1"

May i know where go wrong ?

Paul Yeo

1 Reply
Highlighted
Specialist
Specialist

Re: How to drop SALES_TABLE-1 ?

You are actually loading SALES_TABLE somewhere else in your script with only two Columns SOURCE_, SOURCE.

The "-1" in the table name is autogenerated by Qlik. 

Example:

vamsee_0-1590517122703.png

 

Search your script for that table load and remove it.