Layout Tool - Fields not Appearing

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?

Layout not working.yxmd

Reporting

Accepted answers

alexnajm

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!

Layout not working (1).yxmd

All comments

alexnajm

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

PeterAP

@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-breaks-and-the-Table-gt-Email-tools/m-p/129514#M20961

alexnajm

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!

Layout not working (1).yxmd

PeterAP

@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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317