topic Error in LOAD INLINE statement in QlikView

Error in LOAD INLINE statement

Thu, 03 Dec 2009 19:35:17 GMT

Hi All,

I have types in one table, I loaded that table in the Qlikview. I have written a INLINE statement to map that types.

tab1:

SELECT Type from table A;

Maptopups:
LOAD * INLINE [
Type, Map_Type
, Others
[M Negative Adjus], Others
[M positive Adjus], Others
, E
[E Cancellation], E cancellation
, V
];

I am getting "Garbage value error" after executing the above INLINE statement.

What is wrong in the INLINE statement.

-raghu.

Thu, 03 Dec 2009 19:41:00 GMT

Remove the brackets from the data values.

e.g

M, Others

M Negative Adjus, Others

Anonymous — Thu, 03 Dec 2009 19:42:31 GMT

LOAD INLINE instead of LOAD * INLINE ...
Maybe the [ ] between the LOAD INLINE [ ] could also give problems?

Try something like below:



tab1:
SELECT Type from table A;

Maptopups:
LOAD INLINE [ Type, Map_Type
'M',Others
'M Negative Adjus',Others
'M Positive Adjus', Others
];

Thu, 03 Dec 2009 23:24:00 GMT

Thanks to both of you. Problem with the brackets.

-Raghu