topic Re: Loading fields with content '*' wildcard in QlikView

Loading fields with content '*' wildcard

Wed, 20 Jan 2016 11:32:11 GMT

Good afternoon,

I have a csv file with columns

Role, OrgUnit, Value

ControllerGlobal, CompanyCode, *

ControllerUS, CompanyCode, 2000

After loading , the Value column is empty. Apparently Qlik is not just interpreting the Value column '* ' as text. How can I go about this w/o manipulating the input file in Excel?

Thanks!

Re: Loading fields with content '*' wildcard

jonathandienst — Wed, 20 Jan 2016 11:47:54 GMT

Qlikview determines the column type and format from the first rows it loads for that field. QV presumably sees the Value column as numeric, and the failed numeric conversion of * will return a null. What do you want to do with it?

Re: Loading fields with content '*' wildcard

Wed, 20 Jan 2016 12:38:12 GMT

It would be great to keep it as text with value '*', but anything else (say map it to 'not restricted' or 'all values' will do. I tried

text(Value) as Value1

but it doesn´t change anything.