Incorrect data split

Question

Hello,

Within my dataset some cells contains quotation marks within its values (I guess it stands for inches). It's like:

sthsthsth 1.22",1"

due to this quotation mark Alteryx cannot recognize comma as a column delimiter and incorrectly splits columns. How can I fix this if input is an excel file (not csv)?

ShankerV · Accepted Answer

@Duszko

If I understand your requirement correctly. Alteryx will read the excel file in one column.

Post which you can use Text to columns like below to get the desired result.

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @Duszko

Another way is to use Regex function also like below.

(.+)\s(.+),(.+)

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @Duszko

Check whether it works for you. Hope you are expecting the result like this.

Output:

Input was:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @Duszko

Step 1: Input

Step 2: Record ID

This will help to keep the records in order post we do the modifications and union the result.

Step 3:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @Duszko

Step 4:

Step 5:

The below order is more important to display the exact result.

Step 6: Select tool

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @Duszko

Step 7:

Final output:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @Duszko

Yes you are right on the Permutation.

Have checked with the sample data shared, it works fine as below.

As there was some change in column names, I have modified the below Union tool order.

Many thanks

Shanker V