Render tool not working?

[Vanessa_JWS]

Hi

I have a total of 4 sheets to output into a single file.

Formulas look OK and no errors have been noted.

However, it seems like only 3 sheets have been read. 

What is causing this issue?

Attached screenshot for reference.

Thanks,

[ShankerV]

hi @Vanessa_JWS 

Finally spotted the issue. Hope it helps.

The issue is with the Union tool which you are using as an input to the Basic Table 4.

Its prompting an error no fields were configured for output.

Hence no output is generated due to this error, the basic table is not generating the output.

Kindly fix the issue to get the output from Union tool, so the remaining Basic Table till Rendering tool will work fine.

Many thanks

Shanker V

[Vanessa_JWS]

Hi @ShankerV 

It's actually working fine at my end for the union tool...the error could be due to the removal of data 

[ShankerV]

Hi @Vanessa_JWS 

Yes, you are right. There was the output from the Union tool, we are able to have the column names in Basic table tool.

Can you please share the Messages generated after running the workflow.

It might have some Errors, warning related to Basic Table tool 4 where there is no output from that tool.

Many thanks

Shanker V

[Vanessa_JWS]

@ShankerV 

HEre's the messages after running the workflow:

[ShankerV]

Hi @Vanessa_JWS 

Table 2 and Table 4 has the same column names.

Could you please check and confirm whether the data's are not merged in Table 2 output.

Please check and let me know.

[ShankerV]

Hi @Vanessa_JWS 

Also add a Dynamic rename tool, in between the Union tool and Basic table tool 4.

This will rename all the field/column name with Prefix 4_ so the column name will not be similar to Basic Table 2.

This might will resolve your issue.

Many thanks

Shanker V

[Vanessa_JWS]

@ShankerV - thanks for helping to look into this. E columns for both table 2 and 4 should be the same. The only difference is the dataset

[ShankerV]

Hi @Vanessa_JWS 

So you mean that, the data's from table 4 got merged with table 2 as the columns are same?

Did you ran the workflow after the dynamic rename? Kindly let me know if it worked.

Many thanks

Shanker V

[Vanessa_JWS]

@ShankerV 

The tables are not merged.

To clarify, Table 1 and 3 have the same headers as well but they are reflected in separate sheets.

So the issue is why Table 2 and 4 are reflected in separate sheets, even though they have the same headers as well.

The dynamic rename did not work for me. Thanks

[ShankerV]

Hi @Vanessa_JWS 

Could you please share the workflow, so can check and confirm.

I know it a very big ask, as you have shared only the screenshots of the file.

Based on the file, can locate the issue soon and accurately.

Many thanks

Shanker V