Discussion board where members can get started with QlikView.
in my query, I want to count the COMBINATION of ucn and co_cde. so I have count(concat(ucn,co_cde)
and I group by same count(concat(ucn,co_cde)
so in effect I have count(concat(ucn,co_cde) and the dimension concat(ucn,co_cde)
the result of the field concat(ucn,co_cde) comes back as BLOB (I'm on mysql). how do I change this field not to display 'BLOB'?
(co_cde is defined as smallint and ucn as varchar (6))
Can you attach some sample data and expected result?
Like mentioned above, the informations provided are not enough to help you...
so this is what happens...
here is a sample of the source data and how the result looks like
the ucn&co_cde comes out as a BLOB field...
Don't know what you mean by 'BLOB' field ? you mean they are concatenated ?
it is because you're using concat()..
how do you want them to be loaded ? like the source table ?
when one concatenates on MySql you sometimes get a BLOB field (Binary large object, I think)
dont worry , one of my co workers said I should use cast(ucn&co_cde) as SIGNED. That converts it to an integer.
try like below.
Load * Inline [
ucn, co_cde, period, amount
1, 15, 201801, 22
1, 15, 201801, 33
3, 77, 201801, 100
ucn&' - '& co_cde as "ucn&cde",
Drop Table temp;