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

Data in source starting from random row number

sanketkatoch05
8 - Asteroid

Hi,

 

The position of the data in the data source is not static, that is, it is starting from a random row number.

For eg.: the starting point of the data can be from row number 5 or 10 or sometimes 4. 

 

Is there a way wherein Alteryx always starts digesting the data from respective row numbers. 

The good part here is that the column names are always the same. 

7 REPLIES 7
RolandSchubert
16 - Nebula
16 - Nebula

Hi @sanketkatoch05 ,

 

I think an approach is to load all data starting from row number 1 and remove the header or empty rows. Of course you need a criterion to identify start of data (e.g. first row with numeric value in a specific column). If you provide a sample, help could be more specific. 

 

Best,

 

Roland  

sanketkatoch05
8 - Asteroid

Hi, due to its confidentiality, I cannot share the exact data. Hence I have created a dummy of it, attached doc. 

As you can see, the main data starts from row number 8, and the above columns are just insights into the data (these are random).

Depending on the data, these insights (count) increase or decrease, that is why starting row number of the main data is not static. 

RolandSchubert
16 - Nebula
16 - Nebula

Hi @sanketkatoch05 ,

 

you can read all data, add RecordIds, find the first row with data in column 1 (or e.g. the first "NOT NULL" row in column 3 or 4), and select all rows starting with this one.

 

2021-09-14_14-59-24.jpg

 

You can use the last row before the first data row as column header (as I do in te sample workflow).

 

Let me know it it works for you.

 

Best,

 

Roland

 

 

trevorwightman
8 - Asteroid

I came up with something similar to Roland but uses a few less tools. Instead of finding the first row of data, just find your header row since you said the headers will always be the same. Append that header row back to your main stream of data and filter out any rows with record ID's less than that number. Finally use the rename tool to make the first row of your data the header row. Good luck!

trevorwightman_0-1631637253735.png

 

sanketkatoch05
8 - Asteroid

Hi @trevorwightman, can you share the workflow, so that I can test with the actual data?

trevorwightman
8 - Asteroid

@sanketkatoch05 absolutely, here is the workflow I used. You will just need to reference your file for the input tool. Let me know if it works!

sanketkatoch05
8 - Asteroid

Thank you so much @RolandSchubert  & @trevorwightman for helping out with the prompt solutions. 

Labels
Top Solution Authors