Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to retrieve multiple words in 1 file

Ar13f
10 - Fireball

Dear team and friends,

 

kindly need your help, I am a beginner at Alteryx. I got a request from my boss for the data below. from the table of movements I merely took a few pieces of information and entered them into the resume table. Please give me a solution for working with the data. Thank you for your help.

 

Table MovementTable Movement

 

Table ResumeTable Resume

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @Ar13f 

 

Here is how you can do it. I am assuming the template is maintained.

Workflow:

atcodedog05_0-1628441661229.png

 

1. Configure input tool with first row contains data.

2. Filtering out null rows

3. Using multi-row formula creating block for each account by taking End of Report as reference.

4. Using multi-row formula creating block row id.

5. Our required data is present in 3rd and 4th row hence using filter tool to keep only those both.

6. Splitting to 2 branches to separately extract data from 3rd and 4th row.

7. Using formula to extract data.

8. Using join tool to join on block and get all the required data columns.

 

Hope this helps : )

 

Ar13f
10 - Fireball

Dear @atcodedog05

 

wooooww it's work .... thank you for your help ... one more thing :

what is the difference between row-1 and row+1 in the formula below?

 

"IF [Row-1:F1]=">>>>>>>>>>End Of Report<<<<<<<<<<"
THEN [Row-1:Block]+1 ELSE [Row-1:Block] ENDIF"

 

atcodedog05
22 - Nova
22 - Nova

Hi @Ar13f 

 

Row-1 is row above and Row+1 is row below

 

Happy to help : ) @Ar13f 

Cheers and have a nice day!

Ar13f
10 - Fireball

Dear @atcodedog05

 

Thank you for your explanation ...

Labels