topic Re: Load Statment in QlikView

Load Statment

upaliwije — Sun, 24 Aug 2014 15:23:38 GMT

I have following data in a table

Phone_No Calls

0112-853654	1
0773-412505	1
0773-675076	1
0779-620776	1
0779-620776	1
0779-620776	1
0775-510012	1
0773-758330	1
0773-758330	1
0774-030896	1
0777-442624	1
0776-127635	1
0777-896168	1
0777-345776	1
060-2630504	1
060-2630504	1
060-2630504	1
0714-222012	1
0716-839973	1
0773-405351	1
0112-796896	1
0414-397802	1
0777-447446	1
0773-559133	1
0716-822250	1

I want to load only the data where no of calls >=2 from a single line(highlighted in red). Pls help me to write the script

Re: Load Statment

nagaiank — Sun, 24 Aug 2014 15:52:57 GMT

Try the following script:

LOAD RowNo() as No, * Inline [

Phone_No,Calls

0112-853654,1

0773-412505,1

0773-675076,1

0779-620776,1

0775-510012,1

0773-758330,1

0774-030896,1

0777-442624,1

0776-127635,1

0777-896168,1

0777-345776,1

060-2630504,1

0714-222012,1

0716-839973,1

0773-405351,1

0112-796896,1

0414-397802,1

0777-447446,1

0773-559133,1

0716-822250,1

];

NoConcatenate

LOAD Phone_No where Count > 1;

Load Phone_No,Sum(Calls) as Count Resident X Group By Phone_No;

Left Join (Y) LOAD Phone_No, Calls,No Resident X;

Drop Table X;

Re: Load Statment

MarcoWedel — Sun, 24 Aug 2014 15:54:10 GMT

Hi,

one solution with preceding loads only:

tabCalls:
LOAD Phone_No,
     Calls
Where Calls >= 2;
LOAD Phone_No,
     Sum(Calls) as Calls
Group By Phone_No;
LOAD @1 as Phone_No,
     @2 as Calls
FROM [http://community.qlik.com/thread/130537]
(html, codepage is 1252, no labels, table is @1);

hope this helps

regards

Marco

Re: Load Statment

jagan — Mon, 25 Aug 2014 01:45:18 GMT

Hi,

Try like this

Data:

LOAD Phone_No,

Calls

Where Calls >= 2;

LOAD Phone_No,

Sum(Calls) as Calls

Group By Phone_No;

LOAD Phone_No,

Calls

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Load Statment

Mon, 25 Aug 2014 05:28:55 GMT

Hi,

Use this Script

LOAD @1 as Phone_No,

@2 as Calls

FROM [http://community.qlik.com/thread/130537]

(html, codepage is 1252, no labels, table is @1);

NoConcatenate

tab1:

LOAD Phone_No,

Sum(Calls) as Calls

Resident tab

Group By Phone_No;

NoConcatenate

LOAD Phone_No,

Calls

Resident tab1

Where Calls >= 2;

Drop Table tab;

Drop Table tab1;