I have a csv file which contain Mix format data(Having both number and string values).While using File reader,Book2.xlsx (8.7 KB)
Missing value is coming now as mentioned below.So i cant try any node like number to string(Basically I want these field as string).Is there any way to provide the format in advance?
after previewing your data in File Reader you can click on any of the column headers to change the column property.
Thanku…But still I cant find the value of missing data after executing the file reader node(Although on clicking the column i can see the missing value pattern)
could you please upload your mix-format.csv. Your uploaded file is in excel-format.
Sorry It is not allowing me to attach a CSV file,Tried to zip it and upload,It also does not work.
Only below formats are allowed.
((select images or files from your device (jpg, jpeg, png, gif, knar, knwf, xls, tiff, tif, xlsx, txt, log, lsm, doc, docx, json, xml, pptx))
It would be really helpful If u can convert the XLS file to CSV and use it
Are there quotes around the numbers or around the words TOTAL?
No…If You dont mind ,Can i drop the file to your email id?
You could send it in txt-format. Change the extension.
Mix_format.txt (34 Bytes)
Please find it,but getting the same missing value in file reader.
this is your result with strings
XYZ as missing value pattern and numbers as strings (Type: string)
and this is your result without missing value pattern and all entries as strings (Type: string)
Which of them do you need?
second one,How can i achieve it??
for every column with numbers and strings.
My Bad…Thanku so much @Andrew_Steel…
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.