Drop Table but keep selected dimensions

[george456]

Dear Community

I am a bit unfamiliar with the creation and dropping of Temp tables. I have managed to create my Temp table but now I want to drop the table except on dimension that is the calculated dimension I needed to create

Please can I have some guidance on this matter

Thanks

[Kashyap_R]

Hi

Try by just dropping only the fields

thanks

[Anil_Babu_Samineni]

This will work, But not the good idea

Fact:

Load Name, Class, Sales From Table;

Temp:

Load If(Name='A', Name) as Name_A, Class, Sales Resident Fact;

Temp_Final:

NoConcatenate

Load Name_A Resident Temp;

Drop Table Temp;