Layout Tool - Fields not Appearing
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I have a workflow which combines tables in a workflow using the Layout Tool. I have added some coding to give me line spacing and bold certain items. However, none of my tables are now appearing in the layout tool. Am I missing something?
Usually it would give me the name of the table and then say (bad field type) because of the coding for line spacing and bolding, but now it won't show up at all.
Can anyone help?
Solved! Go to Solution.
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The Formula tool is doing something wonky to your Table - notice the output is much different than the input and they are no longer reporting snippets. Try another Formula or do the formatting in the Table tool directly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@alexnajm it's true, it does but the formula tool is needed to Bold certain elements of text within a cell and to reflect the Newlines.
It has worked fine where I have used similar formulas and the table tool and whilst it doesn't show up in the browse tool at the table level, it usually works fine down the line. But in this instance it doesn't show up in the layout tool.
I've reattached the workflow which shows an example of where it works and an example of where it doesn't.
I found the idea from a previous community post: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Working-with-wanted-line-break...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I noticed it says "bad field" in your working example, so while it may "work" it was probably set up before using the Formula tool so the config is still there.
Off of that assumption, I cut the formula tools from your non-working portion, re-did the Join Multiple and Layout tools so they'd work, and added them back.... sure enough it works now!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@alexnajm Thank you! This worked - I'll remember this for future! It would be nice if we were able to do this in Alteryx without the work around and bad field type.
