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