Forum Discussion

hlombard's avatar
hlombard
Frequent Visitor
9 years ago
Solved

Help parse Accpac journal entries with multiple rows

I have to get hundreds of csv files, each containing thousands of journal entries, in Accpac format, into a table.   In Accpac format, each journal has one Header row (G) and then multiple entries ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    hlombard,

    You would need to filter rows, merge queries, create approrpriate columns to get expected result, for more details, please review this PBIX file.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

hlombard,

You would need to filter rows, merge queries, create approrpriate columns to get expected result, for more details, please review this PBIX file.

Regards,
Lydia

hlombard's avatar
hlombard
Frequent Visitor
9 years ago

Perfect!

 

Thank you!