Create flag to extract the table from multiple tables

Question

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  nameaccountamountrateAlex1234560.23Grace4562510.12Total5797070.35    Default   nameaccountamountrateAlex1234560.23Tom45450.68Total1685010.91            Keep Sheet  nameaccountamountrateAlex123120.25Grace4562510.12Total5792630.37

Output:

Flag    0Trade Sheet   0nameaccountamountrate0Alex1234560.230Grace4562510.120Total5797070.350    0Default   1nameaccountamountrate1Alex1234560.231Tom45450.681Total1685010.911    0    0    0Keep Sheet  0 nameaccountamountrate0Alex123120.250Grace4562510.120Total5792630.370

If you will see 1 is only in the default table

grazitti_sapna · Answer

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

New Workflow4.yxmd

Felipe_Ribeir0 · Answer

Hi @Sshasnk

One way of doing this

MULTIROW.yxmd