How to select column automatically based on header name

[SahadhKuruniyan]

I have an excel file with 60 columns, I have to compare whether the balance amount in this excel file matches with amounts in excel provided by sub-teams(60 different files).

The master file looks like below:

	Team 1	Team 2	Team 3	Team 4	Team 5
Cash	53	87	76	87	43
Bank	43	5	56	87	43
Expense	34	3	5	54	343
Rent	54	8	7	23	7

I am planning to run the flow 60 times by inputting each file from sub teams 60 times (Kindly advise if there are better ways)

Instead of selecting the column from the master file each time using the select tool. Is there any other way to select the column automatically, if we give the column header "Team 1" as Text input.

format of file submitted team would look like below:

	Entity 3
Cash	76
Bank	56
Expense	5
Rent	7

Appreciate an response 🙂

Thanks in advance

[Chantelb · Accepted solution]

 Hi @SahadhKuruniyan,

You can input all the sub team files at once using a wildcard (*) with a data input tool and compare it to the master. The sub team files must have the same schema (format), similarly named and in the same folder using this method. See workflow attached. 

Let me know if this helps

[SahadhKuruniyan]

Thanks alot! Could you help me with one more issue?

I have the table like the below

file name	Account	Difference
Team 1	Cash	0
Team 1	Bank	4
Team 1	Expense	2
Team 1	Rent	5
Team 2	Cash	1
Team 2	Bank	0
Team 2	Expense	1
Team 2	Rent	0
Team 3	Cash	0
Team 3	Bank	0
Team 3	Expense	0
Team 3	Rent	0

I want to convert like the below.

Account	Team 1	Team 2	Team 3
Cash	0	1	0
Bank	4	0	0
Expense	2	1	0
Rent	5	0	0

Can anyone please help 🙂

[Sasidharg]

Hello,

Workflow to  convert the table is attached,

Best,
Sasidhar