How can I let the vale without filed names output in two different excels?

[phoebe_90]

I have three group data. How can I let the value without filed output in specify range in different excels?

For example, four group data.

Company Name

ffff

Report Period

Report Period: Apr 30,2024

Currency

Currency: USD

Output data 

Specify range	sheet1
A1	ffff
A2	Report Period: Apr 30,2024
A3	Currency: USD

Specify range	sheet2
A1	ffff
A2	Report Period: Apr 30,2024
A3	Currency: USD

[gawa · Accepted solution]

hi @phoebe_90 

Do you need to write the same data to multiple excel sheets? If so, create one column to specify the file location, sheet name, and cell range like this.

ffff	C:\Users\hogehoge\desktop\book1.xlsx|||Sheet1$A1:A1
Report Period:xxxx	C:\Users\hogehoge\desktop\book1.xlsx|||Sheet1$A2:A2
Currency:USD	C:\Users\hogehoge\desktop\book1.xlsx|||Sheet1$A3:A3
ffff	C:\Users\hogehoge\desktop\book1.xlsx|||Sheet2$A1:A1
Report Period:xxxx	C:\Users\hogehoge\desktop\book1.xlsx|||Sheet2$A2:A2
Currency:USD	C:\Users\hogehoge\desktop\book1.xlsx|||Sheet2$A3:A3

And, use this option in configuration of Output tool. (Uncheck 'Keep Field in Output')

Maybe it seems you don't need field name in output. Then, check this option.

[Yoshiro_Fujimori · Accepted solution]

Hi @phoebe_90 ,

As @gawa mentioned, you can specify [Filename] + "|||" + [sheet name] in as "File Path" to feed to Output Data Tool.

Sample workflow

Output