posted on March 29, 2023
•
Show version history
Hello. I'm having an issue with the generate metadata report function. I have a template that contains lots of multi-value fields, see screenshot. That template data has to be exported for many documents as a metadata report, to be then imported into MS Power BI, which is a reporting tool. Generating a metadata report with this template results in the multi-value fields being grouped together is a single row, separated by semicolons, see screenshot.
Is there any way to easily split that data up into multiple rows without the semicolons? So that its more friendly to import into PowerBI.
1
0