Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Pick a 100 rows of data after I found a static string

Manjari
8 - Asteroid

Hi All, 

 

I am stuck in parsing this data with multiple file's data stacked one below the other, where I have a static string to be found then filter 100 rows from the row where I found the static string.

In the sample I have 2 file's data and the static string contains "Choco"

 

I have attached the input and the output

 

Attaching images for convenience

Input: 

Manjari_0-1654009221532.png

 

Manjari_1-1654009291647.png

 

 

2 REPLIES 2
binu_acs
21 - Polaris

@Manjari One way of doing this

binuacs_0-1654010718173.png

 

Qiu
21 - Polaris
21 - Polaris

@Manjari 
Basically same with the idea of @binu_acs , but managed to reduce the Multi-Row tool by 1. 😂

0601-Manjari.PNG

Labels
Top Solution Authors