How to get the row item which is associated with other column

Help Activities
1

Hi,

There will be two columns in an excel sheet

custno partno
C1234 C-101
C2345 C-102

So here im looping through partno column and entering the number in an application, but i want to save the folder with the number associated with partno which is custno.

How can i get this?

2

@geetanjali.nerlekar

Use create folder activity and use as below

Path.Combine("basefolderlocation",currentrow.ByField("CustId").stringvalue

Cheers

3

hey i just want to get the row item of custno which is associated with the row item of part no column

4

HI,

If you need to get custno from partno outside ForEachRow loop, it might be better to create dictionary in advance, as the following.

dict = dt.AsEnumerable.ToDictionary(Function(r) r("partno").ToString,Function(r) r("custno").ToString)

Then

dict("C-102")

returns

C2345

image
image813×310 13.4 KB

Regards,

5

Since this data is present in a DataTable.
I guess you would have used a For each Row in DataTable and are looping through different rows one at a time.
currentRow(“partno”).toString would return you partno which you are using in a Web Application.
While creating the folder you can use currentRow(“Custno”).toString in the same loop.

Regards,
Aditya

1 Like
6

Im using reframework, where im getting each transaction item from column “partno”.
im entering this transactionitem into an application, but i want to use the value of cust no associated with partno value for further things.

7

@geetanjali.nerlekar

Then similarly you would get cust no also for the rwlated part no only…please use that

Cheers

8

how to get that?

9

HI @geetanjali.nerlekar

So are you using REFramework with DataRow as transaction item?

if yes, in_TransactionItem(“Custno”).toString should work.

If you are using QueueItem, you might have to add CustNo data also to the queue wherever your are using Add Queue Item.
After it is added to queueitem and is retrieved in RE_Framework, you can use this expression : in_TransactionItem.SpecificContent(“CustNo”).toString

Thanks

10

Hi,

If the data is unique and you require the entire data row, you can use DataTable.Select() or FilterDataTable and get the first item in both the approach. This will return the data row you are looking for. It is better to use the first approach, as the second approach involves another datatable to store the output from FilterDataTable.

Approach 1: Filter using DataTable.Select() expression.
excelDT.Select(“partno='”+currentRow(“partno”)+“'”)(0)

The above expression will return the datarow that matches input partno.

11

is it possible to get values from two columns using in_TransactionItem?
image

12

Yes definitely, you can get that. I see that in PLMID you are getting the CustNo I guess.

You can use this PLMID wherever you want in this sequence.

13

But if you see the second assign activity, PartNO, im getting empty value

14

Can you try to debug it and check in the immediate section whether you have some data in PartNo column of your current transaction item?

Share the screenshot for that if possible.

15

Hi @geetanjali.nerlekar

Use for each row in datatable activity to iterate every row in datatable. Take the two assign activities to store the values.
In 1st assign activity → Variablename1 = Currentrow(“custno”).toString
In 2nd assign activity → Variablename2 = Currentrow(“partno”).toString

You can use the first variable to enter in the web application and
You can use the second variable to save the filename.

Hope it helps!!

16

@geetanjali.nerlekar

Can you show what is your transaction item containing or what data you assigned to it?

Cheers

17

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