Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

Create flag to extract the table from multiple tables

Sshasnk
8 - Asteroid

I have multiple tables in an excel sheet and now I only want to extract that exact table So for that I am creating a flag column like below

I want to create a flag that starts from Default in column 1 and ends at total. Below is the example

Input: 

 

    
    
Trade Sheet  
nameaccountamountrate
Alex1234560.23
Grace4562510.12
Total5797070.35
    
Default   
nameaccountamountrate
Alex1234560.23
Tom45450.68
Total1685010.91
    
    
    
Keep Sheet  
nameaccountamountrate
Alex123120.25
Grace4562510.12
Total5792630.37

 

Output:

 

    Flag
    0
Trade Sheet   0
nameaccountamountrate0
Alex1234560.230
Grace4562510.120
Total5797070.350
    0
Default   1
nameaccountamountrate1
Alex1234560.231
Tom45450.681
Total1685010.911
    0
    0
    0
Keep Sheet  0 
nameaccountamountrate0
Alex123120.250
Grace4562510.120
Total5792630.370

If you will see 1 is only in the default table

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @Sshasnk 

 

One way of doing this

 

Felipe_Ribeir0_0-1674041396647.png

 

grazitti_sapna
17 - Castor

@Sshasnk , Please check if this is what you needed. I have used Multi Field Row to achieve your result.

 

grazitti_sapna_0-1674041870795.png

 

Sapna Gupta
Labels
Top Solution Authors