Based on ID digits length how to swith to different screens

Help Studio
, , , , ,
1

Hi All,

I have a requirement i need to get the data from multiple pages, Here based on ID digits length(7,8 and 9). dynamically different screens will appear how can check the id count before going to right page.

How to switch the pages based on id lengh before going to correct page. not sure where should i write if condition.

Thanks,
Niranjan

2

@Niranjan_k,

Use Switch case like this.

image
image904×292 10.6 KB

Thanks,
Ashok :slight_smile:

3

@ashokkarale thanks for your reply, i have built the default workflow. Now i need to check the id count to move different pages not sure where should include the logic,Before search the details or after searching the ID details. thank you

4

it should be after searching the id.

5

@ashokkarale im just searching for function to get id count and use switch fuction together. any sample workflow. please.

ID
LU56790
DE876280
IE1256196

here based on length of ID i have take the data from different screens.

6

@Niranjan_k,

Can you show the screenshot of the problem like what’s your input and what should be the output.

I think I’m not getting the requirement correctly.

Thanks,
Ashok :slight_smile:

7

@ashokkarale Sorry i do not have access to share and upload any docs in internal webpages.
im using on my personal system.

For 7 digits i need to build different workflow with different extract.
For 8 digits i need to build different workflow with different extracts.
For 9 digits i need to build different workflow with different extracts.

How can i switch different workflows based ID count. At the end i need to create one common excel output with all results from 3workflow. I hope i have explained. Any suggestions please.

8

@Niranjan_k,

So what I understood it that you will have 7,8,9 digit ID’s and the logic to extract information is different for each.

If this is correct understanding,

Build different workflow with different extracts and use Invoke Workflow file activity to call/run that logic form the case.

Like this

image

Thanks,
Ashok :slight_smile:

1 Like
9

@ashokkarale Thanks for great logic, Here i have doubt they will group of IDs which includes all the 7,8,9 digit IDs.

End how can i merge all the details into one excel. if we have 3 workflows sorry not sure how to merge the data. End i need to create common output, with all the 7,8,9 digit IDs.

10
  1. Initialize one DataTable variable dtFinal before Switch case.
  2. Define Out argument of Datatable in each data extraction workflow.
  3. After every invoke workflow in switch case, use Merge Datatable activity to meagre the datatable extracted form that particular case into dtFinal

Thanks,
Ashok :slight_smile: