Need Help

[paulwalker]

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.........

[sunny_talwar]

Try this:

IF NoOfRows('PartialReloadTable') > 0

     DROP Table PartialReloadTable;

ENDIF;

PartialReloadTable:

ADD Load  ID,

                 Category,

                 Sales,

                 Test

From Table_Name;

[paulwalker]

Hi Sunny,

Not working..

It's showing script line error..

[Anonymous]

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;

[m_woolf]

Try:

ADD Load distinct

                 ID,

                 Category,

                 Sales,

                 Test

From Table_Name;

[Kushal_Chawda]

If IsPartialReload() then

drop Table Tab;

Tab:

ADD Load distinct

                 ID,

                 Category,

                 Sales,

                 Test

From Table_Name;

else

all other load scripts;

End if  

[sunny_talwar · Accepted solution]

Sorry I missed a then:

IF NoOfRows('PartialReloadTable') > 0 then

    DROP Table PartialReloadTable;

ENDIF;

PartialReloadTable:

ADD Load  ID,

                Category,

                Sales,

                Test

From Table_Name;

[paulwalker]

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.

[Kushal_Chawda]

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.

[Anonymous]

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