Dear
In an incident report I have two data sources:
* A json file with information of a particular incident (for ex incident code)
* Several master data tables with codes and descriptions
On my report, I would like to lookup the description of a specific code in the masterdata table and print it on the report.
I'm trying to do it with a StiFunction directly in a text field, but getting error messages. Can you please let me know what I'm doing wrong?
Are there better ways to do it without using a relation?
Best regards
Manuel
Stifunction vlookup - Error messages
Stifunction vlookup - Error messages
- Attachments
-
- Stifunctions error.png (314.35 KiB) Viewed 79 times
-
- 20250606 report.mrt
- (215.96 KiB) Downloaded 6 times
-
- Posts: 7259
- Joined: Tue Mar 20, 2018 5:34 am
Re: Stifunction vlookup - Error messages
Hello,
Please check the correct arguments for the VLookup function.
Thank you.
Please check the correct arguments for the VLookup function.
Thank you.
- Attachments
-
- Screenshot 2025-06-11 231114.png (115.4 KiB) Viewed 69 times
Re: Stifunction vlookup - Error messages
Dear Lech
Thank you very much, it works finally!
Thank you very much, it works finally!
-
- Posts: 7259
- Joined: Tue Mar 20, 2018 5:34 am
Re: Stifunction vlookup - Error messages
Hello,
You are welcome.
You are welcome.