Forum Discussion
Optional rows process files from a folder
Hi
I have attached two sample files in the zip file and expecting output as below. Trying in power query... any help is appreciated.
Expected columns
Sample d...
Update:
Step 1: Able to parse files from the folder and get the file level info (basic step done)
Step 2: Able to parse and get the file record info and patient info (with the help of my other post reply by "ronrsnfld")
i.e., getting these details good
Step 3: Payment info: Having trouble with getting payment details (when it is multiple page records) and linking back ...
All the payment info rows that are in first page, I am able to get but do not know how to handle if it bleeds into second page ...
| Visit Date | 10-MAY-2023 10:30AM |
| Old Visit Date | 14-MAY-2023 2:30PM |
| Old Balance | $0.00 |
| Bill Amount | $345.00 |
| Bill Paid | $345.00 |
| Total Due | $0.00 |
| Balance Note | Balance will be paid in 21 days |
| Visit Notes | No payment needed (Patient not seen after vitals) |
Note: For some reason, it is not allwoing me to upload the .pbix file, but can upload other files. Like I did for .zip file in the post.