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

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.

Whem.yxmd

Workflow

Tips and Tricks

Join

Accepted answers

binu_acs

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

Whem.yxmd

All comments

binu_acs

@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

binu_acs

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

Whem.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703