[ASK] Error multiple concatenate to table inside loop

rendiyan — Mon, 07 Nov 2016 04:24:41 GMT

Dear Qlik Master,

i have a load script that use loop and works fine, sample like below :

Original Load Script

Marketing_Budget:

LOAD * INLINE [

INITIAL

];

FOR nrow = 0 TO noOfRows('MS_Connection') - 1

LET vDB = peek('ODBC',$(nrow),'MS_Connection');

Let vFlag = peek('PATH_LEGAL',$(nrow),'MS_Connection');

$(vDB);

Concatenate(Marketing_Budget)

SQL select DISTINCT

substring(PROJECTNO FROM 4 FOR 2) AS Code_Branch,

'$(vFlag)' AS Kode_Legal,

ASD.*

from Marketing ASD

;

next;

But when i try to add more script to concatenate to another table, error show up, and the query is like below :

New Load Script
Marketing_Budget: LOAD * INLINE [ INITIAL 1 ]; ErrorLog_Tbl: *LOAD INLINE [ INITIAL_ELT** 1 ]; FOR nrow = 0 TO noOfRows('MS_Connection') - 1 LET vDB = peek('ODBC',$(nrow),'MS_Connection'); Let vFlag = peek('PATH_LEGAL',$(nrow),'MS_Connection'); $(vDB); Concatenate(Marketing_Budget) SQL select DISTINCT substring(PROJECTNO FROM 4 FOR 2) AS Code_Branch, '$(vFlag)' AS Kode_Legal, ASD.* from Marketing ASD ; Concatenate(ErrorLog_Tbl) *LOAD INLINE[ LEGAL '$(vFlag)'** ]; next;

New Load Script

Marketing_Budget:

LOAD * INLINE [

INITIAL

];

ErrorLog_Tbl:

LOAD * INLINE [

INITIAL_ELT

];

FOR nrow = 0 TO noOfRows('MS_Connection') - 1

LET vDB = peek('ODBC',$(nrow),'MS_Connection');

Let vFlag = peek('PATH_LEGAL',$(nrow),'MS_Connection');

$(vDB);

Concatenate(Marketing_Budget)

SQL select DISTINCT

substring(PROJECTNO FROM 4 FOR 2) AS Code_Branch,

'$(vFlag)' AS Kode_Legal,

ASD.*

from Marketing ASD

;

Concatenate(ErrorLog_Tbl)

LOAD * INLINE[

LEGAL

'$(vFlag)'

];

next;

And the error is :

Error New Load Script
Syntax error, missing/misplaced FROM: Concatenate(ErrorLog_Tbl) LOAD * INLINE[ LEGAL 'DTABB0' ] Concatenate(ErrorLog_Tbl) LOAD * INLINE[ LEGAL 'DTABB0' ]

Error New Load Script

Syntax error, missing/misplaced FROM:

Concatenate(ErrorLog_Tbl)

LOAD * INLINE[

LEGAL

'DTABB0'

]

Concatenate(ErrorLog_Tbl)

LOAD * INLINE[

LEGAL

'DTABB0'

]

I've tried to add set ErrorMode=0;

Also i've tried to test with static value for my second concatenate, remove single quote for my second concatenate.

But still, mw second concatenate script doesn't add up.

Why is this happening?

And is there any solution for this issue?

Many thank you,

Best Regards

Re: [ASK] Error multiple concatenate to table inside loop

tresB — Mon, 07 Nov 2016 04:30:55 GMT

Just a quick try: try putting space between 'INLINE' and '[' , like:

LOAD * INLINE [

LEGAL

'$(vFlag)'

];

Re: [ASK] Error multiple concatenate to table inside loop

rendiyan — Mon, 07 Nov 2016 04:40:25 GMT

it works.

what a funny error

thank you

topic [ASK] Error multiple concatenate to table inside loop in QlikView

[ASK] Error multiple concatenate to table inside loop

Re: [ASK] Error multiple concatenate to table inside loop

Re: [ASK] Error multiple concatenate to table inside loop