AutoFit the Column in output and Data Type post segregation

[Ganesh123]

I tried multiple ways but unable to find easiest way of handing the auto fit the all the column in final output. If we have already could you please help me with the solution. 

if not - can we create one additional tool which auto fit and align the data type accordingly. 

2 issue is about post I bifurcate the excel sheet data with multiple workbook data type doesn't show proper. for example Main file contain string and numeric value. post the bifurcate all the number still shows string value only due to every cell has green tick mark. 

[terry10]

Ganesh123, I am having trouble understanding your question. Could you share examples of your data or a workflow?

[Ganesh123]

Sorry, unable to share the data due to data privacy. 

1st Question - how to auto fit all the column from output in excel.

2nd Question - Post I segregate the output from render tool - My output in excel sheet shows green tick though it is number type. we need to manually convert into number. 

[Ganesh123]

Hello Team, Any update on above question. it is been a long time there is no resolution so far it is impacting my work / project

[SBK]

Hello,

Anyone found the answer to this one please? Thanks