Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Loading fields with content '*' wildcard

Good afternoon,

I have a csv file with columns

Role, OrgUnit, Value

like

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!

2 Replies
MVP
MVP

Re: Loading fields with content '*' wildcard

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?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Loading fields with content '*' wildcard

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.

Community Browser