Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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