Basic Table to excel output

[J_Chan]

Hi All, 

I used the 'basic table' to highlight all the cells which are not matching. 

I used the browse tool and it has done exactly what I want.

Now I wanted to use a 'formula tool' and replace the fields to match the column I want it to match.

I thought I would export my data to Excel then use that data for a separate workflow. 

Everytime I try to export it, I get one line of data when using the 'render tool' or 'reporting tool.'

I would like and excel output in the same layout that is shown in the 'browse tool'. 

Please help - I have read all the comments about rendering the file and et but none of them have worked for me. 

[PanPP]

Hi @J_Chan 

You will need to specify an excel file as an output in a render tool to output the table to an excel file.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

[J_Chan]

Hi @PanPP 
Thank you for your response. I did specify an excel file for the output in the render tool and I still got a one line output.

[PanPP]

Hi @J_Chan 

I have uploaded a sample WF that outputs several sheets to an excel file.

Hope this helps, if it does please like the post and mark it as a solution.