Editing a field

Can someone help with the text input tool. I am new to alteryx, trying to clean the data by editing some rows in the spread sheet and inputting dummy values, how can i do that?

Error: Input Data (1): Error reading "C:\Users\GEORGESANI\Desktop\store\mrcons.csv": CSVFile: A field was missing a closing quote in record 254255

Common Use Cases

Accepted answers

LordNeilLord

Hey @razzy

Can you post and example of what you're trying to achieve?

If you post your workflow and a sample of the data, someone will be able to figure it out for you

razzy

Error: Input Data (1): Error reading "C:\Users\GEORGESANI\Desktop\DATASTORE\MRCONSO.csv": Too many fields in record #28115

All comments

LordNeilLord

Hey @razzy

Can you post and example of what you're trying to achieve?

If you post your workflow and a sample of the data, someone will be able to figure it out for you

razzy

Error: Input Data (1): Error reading "C:\Users\GEORGESANI\Desktop\DATASTORE\MRCONSO.csv": Too many fields in record #28115

razzy

The problem was solved with the answer provided. Good job

razzy

I am still having a problem with this editing. I am joining two tables and i am adjusting the delimiter as \0 because of the error of too many fields. No i am having another error missing field. Of which the column exists in both tables

First Error :Error: Input Data (2): Error reading "C:\Users\GEORGESANI\Desktop\DATASTORE\MRCONSO.csv": Too many fields in record #28115

Second Error after adjusting the delimiter to \0

Error: Join (16): No fields or a different number of fields selected for Join

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703