Hello , please i have a excel file that containe a line with title but i want to remove theme and import only the rest . I uploaded the file when you open it you will understand . Pleaase Help and thnx for all
Hi @Ayari ,
Unfortunately I can't run your workflow, getting an error with your Excel file. Can you share a screenshot of your data ?
I hope you can see it , Actually i want to juststart manipulationg the data that start from line 4
Then you can use Sample tool the way you did, skipping first 3 rows, but not using the group by option !
Hi @Ayari
You can use workflow like below.
Workflow:
Hope this helps : )
that didnt work , It delete the line that containes the titles , i took an exemple of the excel file , i hope it would work for you ,
@atcodedog05 got your back with his solution I think !
Yup, thats right can you give my above workflow a try 🙂 and let me know if you are facing issues.
thnx for you all but i got this error !
That's the error I got !
You are missing access driver 2010. It needs to be installed.
Let me provide you an installation link.
You can refer this link https://community.alteryx.com/t5/Engine-Works/Access-Driver-Install-for-xls-File-Acess/ba-p/90145
And install the required drivers. Access 32-bit 2010 driver
Ok i m waiting for the IT to install it on my laptop of work , please i have one last question if i have two or more excel file and i want them to be after the workflow in one excel file but in two sheet how can i doo it?
Hi @Ayari,
Step -1: Read the different files.
Step -2: Use output tool to output to same file different sheet.
Like below.
To process records below the header/sub header starting with Row4, configure option 7 in the Input Data tool to start at Line ('row') 3...
I installed what you sent me but the same error keep apearing to me!! do you have a solution?
Did you restart the system? Whats the error your are getting?
Hi , i m getting this error
Microsoft JET Database Engine: External table is not in the expected format.\3274 = -328602519
i dont know what to do
