Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yamananalytic
Contributor II

unknown statement drop table

Hi guys,

when i compile the script this error is occurred.

For each vTable in $(list1)

  inner JOIN ([NewData.Name]) LOAD * RESIDENT [$(vTable)];

  let o=pick(wildmatch(vTable,'*NewData.Name*'),'1');

  if o <> 1

  then

  Drop Table $(vTable);

  End If

Next vTable

I have this error :

Unknown Statement  : then Drop Table NewData.Surname.

notice :

NewData.Surname is the table which i want to drop.

stalwar1

swuehl

Tags (1)
1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: unknown statement drop table

Try this

if o <> 1  then

Drop Table $(vTable);

End If;

2 Replies
antoniotiman
Honored Contributor III

Re: unknown statement drop table

Try this

if o <> 1  then

Drop Table $(vTable);

End If;

yamananalytic
Contributor II

Re: unknown statement drop table

Thanks.

it is working.

Community Browser