How to Clean Unstructured Data Table

roysupriya21 · June 10, 2021, 7:46am

hello all,

I have an excel sheet which is unstructured .
UnstructureData.xlsx (40.8 KB)
please check the UnstructureData.xlsx
Now my requirement is to structure the data table . The data table should be like this
StructureData.xlsx (25.4 KB)
I have to make the UnstructureData.xlsx to StrctureData.xlsx .

Would you please suggest me how would I clean the excel file and make that like StructureData.xlsx

Thanks in Advance

lojyehuang · June 11, 2021, 6:03am

@roysupriya21
I build datatable(structured) then add data row from unstructured.
Forum0611.zip (35.8 KB)

roysupriya21 · June 14, 2021, 10:02am

hey thanks for your reply . would you kindly check why the date column value showing like “44228”
date
Thanks in Advance

lojyehuang · June 15, 2021, 12:56am

@roysupriya21
Because of Cell Format.

When I change format to Date, I can see the correct content.

Topic		Replies	Views
Reading unstructured data in csv file Help excel , csv , activities , question	4	1781	November 11, 2019
Date format from un structure to structure Date format Activities excel , activities , question	13	807	April 27, 2021
Usntructured Data to Datatable Activities excel , activities , question	2	325	July 28, 2023
Iterate through generated data table then output selected rows, then add that output to specific excel columns Help datatable , excel	11	1062	October 14, 2019
How do i structure/filter unstructured data? Help datatable , data_scraping	15	2482	October 13, 2019

How to Clean Unstructured Data Table

Related topics