Union issue

Question

Hello everyone,

I'm using a union tool with two inputs (one from a select tool "with no data just headers") , ( the other one is from text input only headers with no data) -> the output of the union is "No data available" :)  isn't it supposed to get me only the headers?

(After the union tool there is a basic table tool, it should read what union output then reflect as a table so for this case it also gives me "No data available")

For your information, I've tried to connect text input only directly to the Basic Table and it gave me the headers, but when I tried to do the same thing with the select is gives me "No data available") :)

So I've tried to connect each tool before the select tool but all of them gave me "No data available"  :) !

What do you think the issue is?

Thank you in advance

ShankerV · Answer

hi @MonaAlmutairi

As mentioned in the previous reply, Issue 1 in the union tool can be rectified with the Configuration.

On the Issue 2, we can overcome by taking the count.

Post Union tool, add Count records tool.

Use the Union tool.

Then table tool as usual to get the output.

But the trick here is, Remove/Deselect the Count so that it will not display in the Table output.

so You will get the desired output of Only Headers with no data's.

Hope it helps!!!

Feel free to ask if you have more questions!!!!

Many thanks

Shanker V

ShankerV · Answer

Hi @MonaAlmutairi

Without screenshots or workflow, will be very difficult to address the issue.

But could you please check whether you have the same settings in Union tool.

Many thanks

Shanker V

ShankerV · Answer

Hi @MonaAlmutairi

On issue 2, when Basic Table is linked with Union (containing only headers) or Directly with Text tool (containing only headers).

The output is No data available.

Many thanks

Shanker V