topic Re: Why & When 'Garbage after statement' comes? in QlikView

Why & When 'Garbage after statement' comes?

dmohanty — Tue, 12 Mar 2013 08:34:49 GMT

I want to use like this above. Here I am getting a 'Garbage after statement' error. However if I am doing a Set errormode = 0, this is avoided and table loads fine.But I dont want to keep the rrormode = 0.

Coul you please suggest how to use this variables? Please test and let me know.

Re: Why & When 'Garbage after statement' comes?

sushil353 — Tue, 12 Mar 2013 08:41:25 GMT

try to make it in single quote.

'$(tableString)' & '$(concatenateSting)':

Re: Why & When 'Garbage after statement' comes?

Tue, 12 Mar 2013 08:48:15 GMT

If that is exactly what you have in your load script, you are missing a semi-colon after the $(ConcatenateString) part.

Re: Why & When 'Garbage after statement' comes?

jagan — Tue, 12 Mar 2013 08:52:50 GMT

Hi,

Try this script

TempOrders:

LOAD

'test' AS Category

AutoGenerate(0);

SET vConcatenate = 'Concatenate(TempOrders)';

SET vTableName = 'vTempOrders';

$(vConcatenate)

LOAD * INLINE [

Re: Why & When 'Garbage after statement' comes?

dmohanty — Tue, 12 Mar 2013 09:16:02 GMT

Unfortunately, putting a semicolon (;) or a colon (:) ,not working.

If Errormode = 0, then this is avoided and working. But I don't need to use that.

Any other solutions please?

Re: Why & When 'Garbage after statement' comes?

dmohanty — Tue, 12 Mar 2013 09:22:26 GMT

I have one more scenario like this. So I need a common solution for these 2 syntax error images.

Here also I am unable to fix the syntax issue. Any suggestions please????

Re: Why & When 'Garbage after statement' comes?

kaushiknsolanki — Tue, 12 Mar 2013 09:58:41 GMT

Hi,

First of all you dont require to give table alice name before concatenate statement so remove $(tableString):

Secondly you need dont need to use the single quote when defining the variable with set statment.

So your variable defination will be

set _SupplierSelectionSql String = And SUPP_ID in (1);

Regards,

Kaushik Solanki