Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
[M Negative Adjus], Others
[M positive Adjus], Others
[E Cancellation], E cancellation
];
I am getting "Garbage value error" after executing the above INLINE statement.
What is wrong in the INLINE statement.
-raghu.
Remove the brackets from the data values.
e.g
M, Others
M Negative Adjus, Others
Remove the brackets from the data values.
e.g
M, Others
M Negative Adjus, Others
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
];
Thanks to both of you. Problem with the brackets.
-Raghu