Error in LOAD INLINE statement

[#1]

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.

[#2 · Accepted solution]

Remove the brackets from the data values.

e.g

M, Others

M Negative Adjus, Others

[Anonymous]

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
];

[#4]

Thanks to both of you. Problem with the brackets.

-Raghu