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.

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
15 - Aurora

@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
Top Solution Authors