Extract Data from Table

[NISHITHA]

Hii Team,

We have Sheets in Below Format

How can we Extract
Document Data= ANK

We have different Codes
NY01
KN01

Document Data is Present within AN- Followed by Code

i.e
AN-NY01
AN-KN01

How can we extract document data from these different sheets

Attached sheet for reference
NY_KN.xlsx (6.1 KB)

Thanks in advance

[vrdabberu (Varunraj Dabberu)]

Hi @NISHITHA

If you want to extract the sheetnames then you can use For Each Sheet in SpreadSheet acitivity and inside that you can continue with the further process by passing currentItem.

currentItem inside For Each Sheet in Spreadsheet will print the sheetnames present in the excel.

Check the below for for better understanding:

Regards

[NISHITHA]

Hello @vrdabberu

We need to Extract

Document Data for each code

Example
In AN-NY01 we extract ANK

In AN-KN01 we need to extract AN-KN01

[vrdabberu (Varunraj Dabberu)]

Hi @NISHITHA

Then, please follow the below process:

In the activity of Read Cell in Sheet please click on + and Open the Advanced Editor and pass currentItem.

Output:

Regards

[NISHITHA]

Thanks @vrdabberu

Is there a dynamic approach to extract based on row with Document Data

Get corresponding column value