Discussion Board for collaboration related to QlikView App Development.
I have following sampae data in my data table. In my data load script I want to segregate codes with at least one letter Eg : 5KDIR,DIR22, SSDIR into category1 and Code with digits into category2. Kindly help me to write the syntax.
Go to Solution.
If there is no possibility of no letters but special characters, you could easily get it like:
If(IsNum(CODE), 2, 1) as Category
try this code in your load script for your requirement
load If(IsNum(CODE),CODE) as Category1,if(IsText(CODE),CODE) as Category2 ;
load * Inline [
this is output