How to combine two different data in one output but in different tabs/sheets.

[Devika]

Hello,

Request someone to help me with the below query.

I have two data from two different applications for which I had to to formulate and now for the output i want the two data to be on one excel but different sheets .I'm unable to use the joint tools has both are very different data. Please help me to have one output with both the data in different sheets.

[binuacs]

@Devika  you need to create a FilePath in the formula tool like below and connect to the output tool and use the FilePath 

Note: you need to create seperate FilePath with different sheet names

eg:  for first tab "Path"+"ExcelName.xlsx|||"+[DATA] - Replace the path with original path and ExcelName with your excel sheet name, [Data] is will be assigned to "Equilend"

[Devika]

Hello Binu,

Thanks ,Can you share the workflow so that i can try running it please

[binuacs · Accepted solution]

@Devika  I updated your workflow. you need to update the actual path in the FilePath variable