Dynamic "Sample"

[bakaidora]

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

[DataNath · Accepted solution]

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

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