script help

[bharatkishore]

HI All,

I have the follow code in script:

M:

load Distinct

EquipmentId,

[Part Group],

Key_EMS,

System_Code

Resident T1;

left join(M)

M1:

load

Key_EMS, Install_Date,

Removal_Date,

Material_Age,

if(Total_Quantity_Installed>=1,1,Total_Quantity_Installed) as Total_Quantity_Installed

Resident MAWhere Total_Quantity_Installed <> 0;

drop Table M;

DROP Table MA;

But the <> 0 is not working i am still getting 0 records.

Can you please help me where i am doing wrong.

Thanks,

Bharat

[bharatkishore]

I have added the below code:

Material_Master_final:

load Distinct

EquipmentId,

[Part Group],

Key_EMS,

System_Code

Resident Materials_Master_Raw;

left join(Material_Master_final)

load

Key_EMS, Install_Date,

Removal_Date,

Material_Age,

if(Total_Quantity_Installed>=1,1,Total_Quantity_Installed) as Total_Quantity_Installed

Resident MaterialAgeTable   ;

drop Table Materials_Master_Raw;

DROP Table MaterialAgeTable;

Final:

Load * Resident Material_Master_final

Where  not(isnull(Total_Quantity_Installed)) ;

But this table is not loading at all.

[olivierrobin · Accepted solution]

as it has the same structure as the preceeding table, they are concatenated

don't forget to use the noconcatenate prefix

[bharatkishore]

Thanks a lot Olivier for your help..

After using Noconcatenate i dropped the final table. Then i have >0 instead of not is null and then it is working..

Thank you so much..