Challenge #2: Preparing Delimited Data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
greegotr
7 - Meteor
01-11-2023
05:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solved! Thank you for these challenges.
hardikkanabar
6 - Meteoroid
01-11-2023
05:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Challenge Solved, used tools Text to Col, Data Cleansing, Date Parse and Select tool.
razconst
6 - Meteoroid
01-11-2023
05:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solved using tools: Text to columns, Data Cleanse, Date Time Convert, Select.
joeoswald614
6 - Meteoroid
01-11-2023
05:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Used text to columns to split to 3 columns
Data Cleansing to remove punctuation from 1
DateTime to convert 3 to Date
Select Tool to rename key fields and eliminate extra fields
Data Cleansing to remove punctuation from 1
DateTime to convert 3 to Date
Select Tool to rename key fields and eliminate extra fields
A fun challenge!
anay_zinje
7 - Meteor
01-11-2023
05:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solved,
Used text to column, data cleansing and select tools to solve this challenge.
Vas2665
5 - Atom
01-11-2023
05:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
use Text to column - Data cleansing - date time - select tool
Anand_Parekar
7 - Meteor
01-11-2023
05:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to Solve!
rchaidez
6 - Meteoroid
01-11-2023
06:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solved using the following tools: Text To Columns, Data Cleansing, DateTime and Select.
Tanbir89S
6 - Meteoroid
01-11-2023
07:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solved! Solved!
Steps to be followed -
- Text To Columns
- Data Cleansing - Unselect (2) and (3), Check Punctuation additionally with the default selection.
- Date Time - Custom - "dd-Mon-yy"
- Select Tool - Check (1), (2) and (Date Time Out) and rename it to respective column Names
Here you go.
Aayushah
6 - Meteoroid
01-11-2023
08:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Enjoyed doing this!