Hi Mohamed,

Similar post is available, click here . 

Hope it helps.

Hi Mohamed Wasfy,
Sometimes as per our logic, we need to convert our existing data (like DatetimetoDate(), Integertotext(), etc) in the aggregate itself.

This type of practice is called typecasting, we need to avoid it because while getting data it will put more effort into getting converted data.


Regards,

Hi,

First what is typecast : As mentioned by others conversion of data type from one to another.  Like Integer to Text etc.

How you can do in Aggregate : In aggregate you can add new column and in that column you can do type casting (data type conversion). 

Why you should avoid it : It takes extra processing so impact the performance and also may lead to exceptions. Like trying to convert a text value to Integer. It will work until we have numbers in text but if there is any other characters it will throw an exception.

regards

Thank you Gentlemen For That Great Explanation.❤️❤️❤️