Invoice Number Disappear from the output

[SH_94]

Hi Community,

Currently i have build the workflow and it give me different result. However, the details of invoice had been truncated and it is different as per the original one in the workflow. Below is the screenshot from the workflow.

However, it is being truncated when we rendered in the excel file. For example , the first row of the screenshot above will show 0004686 and the last number which is 2 had been truncated.

May i know if anyone has the experience before and how we going to fix this error? I had put the format below for the invoice column.

many thanks for your help.

[Emil_Kos]

Hi @SH_94,

Does your invoice number contain any letters? If not maybe you can change it to double and check if this issue still occurs. 

[SH_94]

Hi @Emil_Kos ,

Yes, there are letters under this column. I am trying to adjust the size of table before generating the output.

Secondly, may i know how can i render out the table so that it able to produce different table in multiple tab under one excel file. Below is my current workflow and would like to know how to proceed from there.

Thank you.

[pedrodrfaria · Accepted solution]

Hi @SH_94 

Use the below WF to understand how to output to a single excel files with multiple sheets: