How to drop SALES_TABLE-1 ?

paulyeo11 — Sat, 23 May 2020 04:17:26 GMT

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

Re: How to drop SALES_TABLE-1 ?

vamsee — Tue, 26 May 2020 18:19:58 GMT

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.