We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Delete of some Line

Ayari
8 - Asteroid

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

18 REPLIES 18
Jean-Balteryx
16 - Nebula
16 - Nebula

That's the error I got !

atcodedog05
22 - Nova
22 - Nova

Hi @Ayari 

 

You are missing access driver 2010. It needs to be installed.

 

Let me provide you an installation link.

atcodedog05
22 - Nova
22 - Nova
Ayari
8 - Asteroid

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? 

atcodedog05
22 - Nova
22 - Nova

Hi @Ayari,

 

Step -1: Read the different files.

Step -2: Use output tool to output to same file different sheet.

 

Like below.

atcodedog05_0-1627643414421.png

 

Hope this helps : )

 

HomesickSurfer
12 - Quasar

Hi @Ayari 

 

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...

 

Capture.PNG

Ayari
8 - Asteroid

I installed what you sent me but the same error keep apearing to me!! do you have a solution?

atcodedog05
22 - Nova
22 - Nova

Hi @Ayari 

 

Did you restart the system? Whats the error your are getting?

Ayari
8 - Asteroid

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

Labels
Top Solution Authors