How to drop SALES_TABLE-1 ?

[paulyeo11]

Hi All

My Table model :-

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

[vamsee · Accepted solution]

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:

Search your script for that table load and remove it.