Data exported to excel has some limitations that I want to try to resolve (inside or outside of Easymorph)
- Easymorph doesn’t support columns with the same name. I need a way to export multiple columns with the same name. Example:
Value Type Value Type Value Type Value Type
1 M 2 A 3 GA 4 PL
2 C 3 E 4 AA 6 EE
Currently, it exports as follows:
Value Type Value(2) Type(2) Value(3) Type(3) Value(4) Type(4)
- I need to insert a row above the header row after export:
Before:
After:
- Is there a way to produce a list of errors or show errors as red?
In our use-cases, we often do lookups. Sometimes those lookups are invalid, so what I do is to set value to: #NOT FOUND - [COL] so we can review later.
Unfortunately, it is not easy to spot those errors in large exported files in multiple columns. Is there a way to generate a file with a list of lookup errors? If not, is there a way to post-process files to mark cells as RED?
Ideally, we also want to have a list of EasyMorph errors (e.g. conversion issues, etc.)
Thank you!