Nested if else not working

Learning Hub
,
1

Hello,

please check my below requirement

Merge FName and LName to Name, Phone1 will be Phone and remove Phone2 and Web column from the output, Filter data where state is ACT and NSW and write these data in a dedicated sheet, i.e, for ACT write the data in ACT sheet or sheet2 and for NSW write in sheet NSW or sheet1 visa-verse, and for rest of the data in a separate workbook.

Please note file path should be dynamic, and for name part if required it will be flexible so that whenever or wherever required we can use as per requirement.

now i have uploaded my work flow and also main excel sheet. please check the nested if else part. it is not working .please suggest if i have missed something .

thanks in advance
Excel_Excercise.zip (55.4 KB)

2

You can also Use Switch instead of Nested If

1 Like
3

thanks . can i have example or can you please apply on my workflow .

thnks in advance .

4

Ya sure

5

Excel_Excercise.zip (166.0 KB)

As per Nested If

Using Switch
Excel_Excercise (2).zip (168.3 KB)

6

both nested if else and switch case did not fulfil my requirement.

my requirement is

Filter data where state is ACT and NSW and write these data in a dedicated sheet, i.e, for ACT write the data in ACT sheet or sheet2 and for NSW write in sheet NSW or sheet1

and for rest of the data in a separate workbook.

7

Then use Filter Datatable for this i havent look your operations

8

it will be very nice if you give example on my workflow.

9

Main.xaml (61.1 KB)
TRY THIS

10

no . again i have to put a for each loop because i have to marge first name and last name also. and nsw will go to sheet1 and act will go to sheet2 of same work book.

11

Then after filter datatable u can use for eachfor other operation