Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
as it has the same structure as the preceeding table, they are concatenated
don't forget to use the noconcatenate prefix
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..