Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in LOAD INLINE statement

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.

1 Solution

Accepted Solutions
Not applicable
Author

Remove the brackets from the data values.

e.g

M, Others

M Negative Adjus, Others

View solution in original post

3 Replies
Not applicable
Author

Remove the brackets from the data values.

e.g

M, Others

M Negative Adjus, Others

Anonymous
Not applicable
Author

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


Not applicable
Author

Thanks to both of you. Problem with the brackets.

-Raghu