Forum Discussion
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 columns are related to : client name, weight delivered and notes/remarks. Hence there should be only three columns.
Link to data below, I need a powerquery tip to resolve the issue.
Thanks!
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.
5 Replies
Hi medmbchr1989
l am unable to open the link provided by you medmbchr1989
Import the data into power query editor. In power query editor split column using delimeter or by position and make nessary transformations if needed .
if You found this information useful accept it as solution
Link expired, there you go: https://we.tl/t-m9dLRZEMEs
Please advise if it's working
shamili please advise
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.
