Hello, I haven't been able to use the standard import excel option with the attached file and hoping to get suggestions for Sheet1: * Header Record Example Date range* 1/1/2021 - 12/31/2021 * Header Record Example Resource* Bob, Joe, Stephen * Detail records have the remaining columns; Date, Time Entry, Activity, Report Hours, Comment I've included an 'Output' worksheet in the attached. Thank you! Comments.xlsx

Import excel file when the first row is not a header

Hello,

I haven't been able to use the standard import excel option with the attached file and hoping to get suggestions for Sheet1:

Header Record Example Date range
- 1/1/2021 - 12/31/2021
Header Record Example Resource
- Bob, Joe, Stephen
Detail records have the remaining columns; Date, Time Entry, Activity, Report Hours, Comment

I've included an 'Output' worksheet in the attached.

Thank you!

Comments.xlsx

Help

Accepted answers

binu_acs

@joesparty

Report1.yxmd

All comments

@binuacs that worked, thanks and I learned about Dynamic Rename. Question, when I try to replicate you Input Data on my original file I get the following error:

The Excel archive is corrupted: shared strings root=x:sst

Have you ever encountered this error?

binu_acs

@joesparty no, I did not encounter such error. I just used your excel file as input

joesparty

Something else I noticed with your Input Data, how did you get the Table or Query to read 'Sheet1$'? I only get Sheet1.

binu_acs

@joesparty

Alteryx by defaults adds $ at the end of the sheet names.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703