Find function in block alghoritm
Hello
I tried to use the find function in an alg. block but it doesn't work. Probably it's not supported , but I would like to be sure about it.
For sure I can do this using nexcel, but in this case I would avoid it.
thanks
Answers
-
I had the same situation recently when I needed to know the number of spaces in an entity description. I found the same problem with the layout algorithm. For me the answer was to create a cube (e.g. "# of spaces") to store the value. I extracted the entity to file then created an ASCII protocol to read the extract. The find() function is supported in the ASCII protocol ETL so I just used the ETL to populate the value in my "# of spaces" cube.
Not as neat as having it in a layout algorithm but actually was more use in my application.HTH
Robert
3 -
as you can see here BOARD Layout Algorithm Syntax , there is no "find"-function available in BOARD's Layout Algorithms.
Although I don't know your data model, I'd propose using the entity describing wheter you'd be looking at a painting or not as an additional block (hidden) in your layout and refer to that block to determine whether to display a "Y" or "N" per record.
Or--even easier, attach this entity as attribute to your "Name" entity and display the contents of this attribute in your layout.
But maybe you are aiming at something else--it would be helpful to know what you'd like to achieve...
Kind Regards,
Helmut
2 -
Thanks to both of you.
I also thought about these solutions (reliable and effective!), but since my need is related to this report only and for a very limited data subset, I would find a "light" solution. I guess nexcel works fine for my purposes.
thanks again!
Best regards
Daniele
3
Categories
- All Categories
- 1.8K Forums
- 1.7K Platform
- 109 Academy
- 283 Resources
- 3 Community Captains
- 1 About Community Captains
- 1 Meet the Community Captains
- 1 Topics & Thought Starters
- Board Manual
- 50 Best Practices
- 42 How-To Guides
- 25 Board Advocacy Program
- 159 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- Academy
- 2 Board Academy
- 7 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.1K Idea Exchange
- 310 Partner Hub
- 2 Solution Sales Toolkits
- 92 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP