Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Layout Tool - Fields not Appearing

PeterAP
8 - Asteroid

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?

 

 

4 REPLIES 4
alexnajm
18 - Pollux
18 - Pollux

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
8 - Asteroid

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

alexnajm
18 - Pollux
18 - Pollux

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!

PeterAP
8 - Asteroid

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

Labels
Top Solution Authors