Data in source starting from random row number

sanketkatoch05

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.

Datasets

Input

Parse

Common Use Cases

Best Practices

Data Investigation

Accepted answers

RolandSchubert

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.

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

StartRow.yxzp

AlteryxTrev

@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!

First Row.yxmd

All comments

RolandSchubert

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

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.

Dummy.xlsx

RolandSchubert

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.

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

StartRow.yxzp

sanketkatoch05

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

AlteryxTrev

@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!

First Row.yxmd

sanketkatoch05

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703