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 | |||
name | account | amount | rate |
Alex | 123 | 456 | 0.23 |
Grace | 456 | 251 | 0.12 |
Total | 579 | 707 | 0.35 |
Default | |||
name | account | amount | rate |
Alex | 123 | 456 | 0.23 |
Tom | 45 | 45 | 0.68 |
Total | 168 | 501 | 0.91 |
Keep Sheet | |||
name | account | amount | rate |
Alex | 123 | 12 | 0.25 |
Grace | 456 | 251 | 0.12 |
Total | 579 | 263 | 0.37 |
Output:
Flag | ||||
0 | ||||
Trade Sheet | 0 | |||
name | account | amount | rate | 0 |
Alex | 123 | 456 | 0.23 | 0 |
Grace | 456 | 251 | 0.12 | 0 |
Total | 579 | 707 | 0.35 | 0 |
0 | ||||
Default | 1 | |||
name | account | amount | rate | 1 |
Alex | 123 | 456 | 0.23 | 1 |
Tom | 45 | 45 | 0.68 | 1 |
Total | 168 | 501 | 0.91 | 1 |
0 | ||||
0 | ||||
0 | ||||
Keep Sheet | 0 | |||
name | account | amount | rate | 0 |
Alex | 123 | 12 | 0.25 | 0 |
Grace | 456 | 251 | 0.12 | 0 |
Total | 579 | 263 | 0.37 | 0 |
If you will see 1 is only in the default table
@Sshasnk , Please check if this is what you needed. I have used Multi Field Row to achieve your result.