Dynamic "Sample"

Dear All,

I have a use case out of a .csv file.

The first step is that I need to "cut" those lines from the beginning which are not necessary.

But the issue is that sometimes I should remove the row 1-34; sometimes 1-50, other example is 1-123, so it is always different.

The only field which is always the same, that the latest cell which I do not need, contains the following information "[HISTORY DATA]" and this is always the same. So I need everything which is under this line (but this line/cell is moving up or down).

Thanks for your kind help.

Dóra

Preparation

Accepted answers

DataNath

@bakaidora if I'm understanding your request correctly, is this what you need? The workflow assigns a RecordID to each row, before isolating the cell containing [HISTORY DATA] and appending the RecordID of that entry to every row. We then just use a filter to check that the RecordID is larger than that of the [HISTORY DATA] entry:

The select at the end just removes these IDs that we only needed temporarily for the removal:

This will be fully dynamic as the [HISTORY DATA] entry moves up and down throughout the data.

Dynamically keep records beyond certain cell.yxmd

All comments

DataNath

The select at the end just removes these IDs that we only needed temporarily for the removal:

This will be fully dynamic as the [HISTORY DATA] entry moves up and down throughout the data.

Dynamically keep records beyond certain cell.yxmd

Emmanuel_G

@bakaidora You can do the filter before sample or select records tool to remove these lines and be sure that you will not have it again.

bakaidora

@DataNaththanks, it worked.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335