topic Load Script in QlikView

Load Script

upaliwije — Thu, 27 Sep 2018 06:05:51 GMT

Hi Friends

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.

CODE
5KDIR
DIR22
SSDIR
03456
04190
05012
05742

Re: Load Script

tresB — Thu, 27 Sep 2018 06:11:25 GMT

If there is no possibility of no letters but special characters, you could easily get it like:

Load

If(IsNum(CODE), 2, 1) as Category

Re: Load Script

arvind1494 — Thu, 27 Sep 2018 06:20:23 GMT

Hi UPALI,

try this code in your load script for your requirement

Table:

load If(IsNum(CODE),CODE) as Category1,if(IsText(CODE),CODE) as Category2 ;

load * Inline [

CODE

5KDIR

DIR22

SSDIR

03456

04190

05012

05742

];

Re: Load Script

arvind1494 — Thu, 27 Sep 2018 06:23:45 GMT

this is output