Alteryx Designer Desktop Discussions

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

Reading data from Excel File

Alteryxexpert
8 - Asteroid

I have Column A,B,C,D in Excel, I need to read only column A,C,D dynamically. Data looks like below, I need to pick only Item,31-Jan-24 and 29-feb-24 and rest of other columns.

       A             B                           C                                 D

Item31-Dec-2331-Jan-2429-Feb-24
A4,545,4564,545,4564,545,456
B545,654545,654545,654
C465,465,465465,465,465465,465,465
D752,436752,436752,436
E689,535689,535689,535

 

And in the Excel I have 2 Empty rows present above the first rows and 1 empty column IN front of Column A. How to do this ? 

 

2 REPLIES 2
aatalai
14 - Magnetar

@Alteryxexpert  see workflow attached does this help?

Raj
16 - Nebula

@Alteryxexpert Share your sample excel file.
what i understood is the input is having null rows and column and you want to avoid this.

Labels