Hi everyone,
I have a cell which contains embedded new lines. This cell basically has a summary of all work that has been done on a ticket. This may include communication through chat, emails and updates pertaining to the ticket. This information is extracted from SNOW as a csv file which serves as the input for Alteryx. I need to use these cells from the column to look for certain keywords and phrases for analysis in Alteryx. But when I am outputting the information only the first line is being extracted. How do I make the whole data appear in every cell.
Thanks and regards,
Nithin
Solved! Go to Solution.
I believe the error is related to the delimiter as @ShankerV suggested as I can see the data after a "," being excluded. How can I change this setting to include the ",". Since my info contains emails and communications where users may use the comma in their sentences I dont want the information coming after to be excluded
You are supposed to modify the delimiter here as per your input shared.
But point to be noted, changing this will read the file in messy way.
Many thanks
Shanker V
Is there a possible workaround for this situation?
For example, if your data is like this.
A,B,C,D,nobleshanker@gmail.com,shanker@gmail.com
Each , is read as different columns.
Please do the modification in the input file as below
A,B,C,D,nobleshanker@gmail.com;shanker@gmail.com
So the comments column will read as single column.
Logic is the identifier used should be unique, which should not be used in other columns.
Then only delimiter will work correctly.
Many thanks
Shanker V
As it will be difficult to modify in the .CSV file.
Please save with the unique delimiter while saving the csv file like
pipe symbol |
or # symbol.
Many thanks
Shanker V
Hi @ShankerV
Changing the delimiter to | or # merges all the columns into one now 😥.
@Nithinpanicker try to read your input file with the below configuration, and see you are getting all the records?
Tried what you suggested but its combined all the other columns into one now.
Is there a way I can remove the commas from the comments and work notes cells before inputting into alteryx?
For better context:
"Comments and work notes" is a column and the data under the column contains a history of emails and chats. So if there is a comma in those cells data gets excluded.
Changing the delimiter to | or # merges all the columns into one now.
Yes as I said it will mess up the data.
My request was to use the delimiter while saving the .CSV file
Then use the same delimiter when Alteryx Input.
As it will be difficult to modify in the .CSV file.
Please save with the unique delimiter while saving the csv file like
pipe symbol |
or # symbol.
Many thanks
Shanker V
.