topic Re: Need Help in QlikView

Need Help

paulwalker — Tue, 11 Aug 2015 15:59:25 GMT

Hi Community,

ID	Category	Sales	Test
1000	ABC	2000	X
1010	ABX	1200	X
1020	BCA	1500	X
1030	FVC	2500	Y
1040	KNM	3500	Y
1050	hnn	1290	X
1060	yyy	1580	X
1070	Auuu	1289	X

Actually i have one requirement, i want to do Partial reload..

i know concept partial reload... Using ADD attributes

ADD Load ID,

Category,

Sales,

Test

From Table_Name;

If i am reload 2 times, it's coming duplicate values..

i want to load only new records... (using Partial reload)....

Thanks in Advance.........

Re: Need Help

sunny_talwar — Tue, 11 Aug 2015 16:01:16 GMT

Try this:

IF NoOfRows('PartialReloadTable') > 0

DROP Table PartialReloadTable;

ENDIF;

PartialReloadTable:

ADD Load ID,

Category,

Sales,

Test

From Table_Name;

Re: Need Help

paulwalker — Tue, 11 Aug 2015 16:54:03 GMT

Hi Sunny,

Not working..

It's showing script line error..

Re: Need Help

Anonymous — Tue, 11 Aug 2015 17:05:24 GMT

may be try:

LET vNoRows = NoOfRows('PartialReloadTable');

IF vNoRows > 0 then

DROP Table PartialReloadTable;

ENDIF;

PartialReloadTable:

ADD Load ID,

Category,

Sales,

Test

From Table_Name;

Re: Need Help

m_woolf — Tue, 11 Aug 2015 17:12:36 GMT

Try:

ADD Load distinct

ID,

Category,

Sales,

Test

From Table_Name;

Re: Need Help

Kushal_Chawda — Tue, 11 Aug 2015 17:34:37 GMT

If IsPartialReload() then

drop Table Tab;

Tab:

ADD Load distinct

ID,

Category,

Sales,

Test

From Table_Name;

else

all other load scripts;

End if

Re: Need Help

sunny_talwar — Tue, 11 Aug 2015 17:59:00 GMT

Sorry I missed a then:

IF NoOfRows('PartialReloadTable') > 0 then

DROP Table PartialReloadTable;

ENDIF;

PartialReloadTable:

ADD Load ID,

Category,

Sales,

Test

From Table_Name;

Re: Need Help

paulwalker — Tue, 11 Aug 2015 18:46:58 GMT

Thanks for reply everyone...

if(IsPartialReload()) then

Student:

ADD LOAD ID,

Test

FROM

table_Name;

EXIT Script;

ENDIF;

Please can anyone explain this script.... why they are using Exit Script inside.

Re: Need Help

Kushal_Chawda — Tue, 11 Aug 2015 18:55:48 GMT

There is no need for Exit script here. If it's partial reload only the piece of code will run with ADD prefix inside if condition in else rest of the code will reside and finally there will be end if.

Re: Need Help

Anonymous — Tue, 11 Aug 2015 18:56:24 GMT

Hi Paul,

Partial reload is a reload where you can only reload any single table that you want to reload or you can load only that particular table.

so Exit Script inside the script means,to load only that table if its partial load and stop executing rest of the script.

Hope this helps.

Regards

Neetha

Re: Need Help

sunny_talwar — Tue, 11 Aug 2015 19:13:07 GMT

I don't think this script requires IF IsPartialReload() then and the Exit Script, below in itself should be enough:

Student:

ADD LOAD ID,

Test

FROM

table_Name;

Because Add will only work during Partial Reload and there are no other DROP, LET, RENAME statements in here which will unintentionally run during Partial Reload

Re: Need Help

Digvijay_Singh — Tue, 11 Aug 2015 19:37:15 GMT

Right, but Where not exists needed to avoid duplicates in case partial load is run more than once, -

Load * inline [

ID, Category, Sales, Test

1000, ABC, 2000, X

1010, ABX, 1200, X

1020, BCA, 1500, X

1030, FVC, 2500, Y

1040, KNM, 3500, Y

1050, hnn, 1290, X

1060, yyy, 1580, X

1070, Auuu, 1289, X

];

Add Load *

inline [

ID, Category, Sales, Test

1080, ABC, 2000, X

1090, ABX, 1200, X

1100, BCA, 1500, X

] Where not exists(ID);

Re: Need Help

qlikviewwizard — Wed, 12 Aug 2015 06:39:22 GMT

Nice trick Sunny T. Thank you.