Incorrect data split

[Duszko]

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 solution]

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