Learning data manipulation in Datatable

Help Studio
1

Hi Team,

I want to give below conditon for bot. Coud yyou please with xaml file to me

  • Use Filter DataTable / LINQ to search for the row in In_CostBook where Model/SKU or Description matches the line item.
  • If match found:
    • Extract CostBookPrice (Double).
    • Compute Difference = In_UnitPrice - CostBookPrice.
    • If Difference > 0 → Output = “+” & Difference.
    • If Difference < 0 → Output = Difference.ToString (already negative).
    • If Difference = 0 → Output = “0”.
  • If no match found: Output = “Not Found”.


Thanks

2

@venkateshcheeni09,

As you are learning the tool, I would suggest to build it by learning each component. Until and unless you are building this by yourselves, you won’t learn it right way.

If stuck at any particular issue, try searching here on the forum you will find the answer yourself. If not, help is just a thread away :wink:

Cheers!

1 Like
3

hi, @venkateshcheeni09
Assign → matchRow = In_CostBook.AsEnumerable().FirstOrDefault(Function(r) r(“Model/SKU”).ToString = lineItem Or r(“Description”).ToString = lineItem)

If matchRow IsNot Nothing Then
CostBookPrice = CDbl(matchRow(“CostBookPrice”))
Difference = In_UnitPrice - CostBookPrice

If Difference > 0 Then
    Output = "+" & Difference.ToString
ElseIf Difference < 0 Then
    Output = Difference.ToString
Else
    Output = "0"
End If

Else
Output = “Not Found”
End If
build this by yourselves copy to @ashokkarale

4

Could you please call me once 9032246038