Forum Discussion
Solved
Data restructuration imported from PDF
Hi I have imported a set of data from 180 files for a daily client delivery log from PDF files. The issue is that some columns overlaped one over the other one and need to be restructured, the co...
as per given data i saw the client names multiple times .first you have to change weight delivered column datatype into wholenumber and then you have to do groupby with client name with sum or average operation with weight delivered column .
by following the above steps you can get your funcationality done.
for your reference see the below screenshot.after completing the above step to add remarak cloumn in to the table add an aditional conditional column and create a new column for remarks and close and apply for the reports.
Link expired, there you go: https://we.tl/t-m9dLRZEMEs
Please advise if it's working
shamili please advise