December 15, 2019

How to convert invalid date formats into valid data formats?

Unclean or Invalid Dates (DMY Format) should be converted to valid data formats. By default, Excel accepts date input in MM/DD/YY format (US format) unless you change the control panel settings of your PC. Example 22.10.2007 or 22/10/2007 date may be considered invalid. Now Splitting name into two columns as the First Name and Last...
Read More

Special Character Symbol List with Shortcodes in Excel

To activate the special character, you need to use an Alt keyboard sequence:   Num Lock key must be pressed, to activate the numeric key section of the keyboard (you can find on right top corner side). Press Alt key, and hold. While the Alt key is pressed, type the sequence of numbers (on the numeric keypad) from the...
Read More

Alteryx Data Types | Alteryx Data Analytics

Alteryx is a Self-service data analytics tool. Alteryx makes the process of ETL easier. Alteryx is a super tool that combines the functionalities required for Data Preparation, Geo-Spatial Analytics, and Data Science. Alteryx has mainly 5 Data Types.   If you want to learn how to use these data types in Alteryx, then check our...
Read More