topic Re: Set limit for mobile number in QlikView

Set limit for mobile number

dhavalvyas — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have mobile number field in my table from which I want to store only valid mobile number in. Csv file. Mobile number should be 10 number only. If greater or less than 10 then it will not store in. Csv

What logic should I apply???

Re: Set limit for mobile number

vishsaggi — Wed, 13 Sep 2017 14:54:15 GMT

What are the values that comes in your mobilenumber field. May be try like:

IF(Len(Trim(MobileNumber)) = 10, MobileNumber, 0) AS ValidMobileNum

Re: Set limit for mobile number

Anil_Babu_Samineni — Wed, 13 Sep 2017 14:55:31 GMT

May be this?

Fact:

Load * From Table;

If Len(Mnum) = 10 THEN

STORE Fact into ....;

EndIf

MsgBox ("Not storing");

Next;

Re: Set limit for mobile number

prieper — Wed, 13 Sep 2017 14:56:08 GMT

IF(LEN(TRIM(MyMobile)) = 10 AND ISNUM(LEN(TRIM(MyMobile)), LEN(TRIM(MyMobile))) AS ValidMobile

Re: Set limit for mobile number

dhavalvyas — Wed, 13 Sep 2017 16:19:01 GMT

My application also contain policy no. field.users requirement is that on daily refreshing data same policy no. and mobile no. does not repeat or exist for next seven(7) days.

so what should logic I apply for this scenario ???

Re: Set limit for mobile number

vishsaggi — Wed, 13 Sep 2017 16:28:57 GMT

Can you explain a little more with an example data and you expected value should be?

Re: Set limit for mobile number

dhavalvyas — Wed, 13 Sep 2017 16:45:32 GMT

In my application there is many fields out of which i wnat only two fields i.e. policy no. and mobile no.,want to store only these two fields into csv.

1> In which mobile no should be only 10 digit if more or less than 10 then it should not store into csv

2> Also same policy no. and Mobile no. should not repeat for next seven(7) days.

after doing these two conditions it should be daily refreshed and get store into sql.

can you tell me step by step process for it ???

Re: Set limit for mobile number

its_anandrjs — Wed, 13 Sep 2017 17:28:57 GMT

Try some this and let me know if there is any date field also also can you share some data to have a look i have some idea then share with you. Then let me know if it is worked for you.

I am taking resident load of your main table and extract only policy no, mobile no but it is not for seven days. Initially it is full loading and after that you have to check it by incremental load.

FirstTab:

Load

Policy_No&'-'&MobileNO as Key

Policy_No,

MobileNO

From FactTable

Where Len(MobileNO) = Right(MobileNO,10);

Store FirstTab into FirstTab.qvd(qvd);

Final:

Load

Policy_No&'-'&MobileNO,

Policy_No,

MobileNO

From FirstTab.qvd Where Not Exists(Key,Policy_No&'-'&MobileNO);

Store Final into Final.qvd;