Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try by just dropping only the fields
thanks
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;