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