CODEWITHSUNDEEP
powerbipowerquerydata-analysispowerbi-desktopalteryx
Soham Chavan
Soham Chavan

Reputation: 1

How do I find a data in multiple sheets of a excel workbook using alteryx or any other software?

I have a file called Tracker.xlsx with such data (below) in a sheet name called Windows. It also has various sheets such as Ubuntu, AIX, etc, with same column names.

IP address Status
10.1.1.0 blank
10.1.1.1 blank

I have another file called OS.xlsx with multiple sheets such as sheet1, sheet2, etc. It also has these following columns (below).

IP address Status
10.1.1.0 Success
10.1.1.1 Pending

So I want to search a IP address from the Tracker.xlsx file of the Windows sheet in all the sheets of the OS.xlsx file. If found then I just want to fetch the status data of that sheet of OS.xlsx to put it into the Tracker.xlsx in front of that IP. As you can see the Tracker file as blank data in Status column.

I tried to do this in Alteryx using dynamic input but then again I got stuck in like "how to search data". I do not know where I am doing wrong. If this is not possible in Alteryx then please specify/recommend me the best software for this task.

Upvotes: -1

Views: 15

Answers (0)

Related Questions