How can we save result Data and Metadata in the same excel and in Different tab
You can with control containers in the latest version of Alteryx (2023.1). Put your workflow in a control container and connect the output of the control container to an Output Data Tool referencing the same file but difference sheet.