How to contain keyword to contain in particular column

Help Activities
, ,
1

Hi Team,

I want to contain queue key to column value and get the result of row item in excel .

I have more queueitem i will pass one by one that queue item should contain column value, if contain all the row item are need.

if queue key is “xxxnew” should contain column value of “BB” whatever value contain that row items are required.

Please help me anyone for this.

Input:
Queue item key is xxxnew

image

Expected out:
image

2

Hi @Raja.G

Try this

DT.AsEnumerable().Where(Function(row) queueKey.Contains(row("BB").ToString)).CopyToDataTable()

image
image603×636 23.5 KB

Regards,

3

Hi @irtetala,

I am facing error “Assign: The Source Contains no DataRows”.

Please share code if you have

Some other queue item also it will come that it will be not contain so only issue came
like “invoice number” for queueitem that is not contains

Regards,
Raja G

4

@Raja.G

Try like below

This image displays a sequence in UiPath workflow, where data is read from an Excel workbook, processed based on a condition, and then written back to the workbook. (Captioned by AI)
This image displays a sequence in UiPath workflow, where data is read from an Excel workbook, processed based on a condition, and then written back to the workbook. (Captioned by AI)818×1168 55.6 KB

arrDr = DT.AsEnumerable().Where(Function(row) queueKey.Contains(row("BB").ToString)).ToArray

Sequence16.xaml (26.7 KB)

Regards,

1 Like
5

Hi @lrtetala ,

I couldnt able to download your code.

Document is invalid error came

Regards,
Raja G

6

@Raja.G

image
image1074×335 17.6 KB

This image depicts a conditional workflow in a programming environment where it checks if "arrDr.Any" is true, then assigns "arrDr.CopyToDataTable" to "dtResult", otherwise assigns "DT" to "dtResult." (Captioned by AI)
This image depicts a conditional workflow in a programming environment where it checks if "arrDr.Any" is true, then assigns "arrDr.CopyToDataTable" to "dtResult", otherwise assigns "DT" to "dtResult." (Captioned by AI)731×600 36.9 KB

Regards,

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.