Table not appearing on all documents

[elsieahteck]

Hello everyone!

I added a Table to a Report Text, however when rendering - the table does not appear on all the documents.

Can somebody help please?

Thank you in advance.

[Qiu]

@elsieahteck 
Maybe we should use the append tool rather than union in this case.
Union is like only put the 2 inputs together, which Append can generate extra records to match with another input.

[elsieahteck]

Thank you for your quick response and solution @Qiu.

But what if we have more than 2 input streams?

The Append tool wouldn't really work in that case?

Please advise. 

[TonSquared · Accepted solution]

Hi, I think this simple idea will work on your problem. Adding a dummy field with the same data will let you join all the streams without losing any data like what you've shown above.

Here is an example, i've created a dummy "J field" and i've join it by "J field' so everyone will push through without losing any streams.

We've come with this idea while we are creating alteryx apps :)

Let me know if this helps

Please mark as a solution if this solved your problem.

[elsieahteck]

Amazing! Thank you very much @TonSquared 😀👍

[elsieahteck]

Hi @TonSquared,

Is it possible to pull the Available Fields of our input file and use them as variables in the Table please?

[TonSquared]

Yes you may. But i guess you need to rearrange your tools to make this things happen according to your preference

Like this below

[elsieahteck]

Thank you so much @TonSquared 😀