Linq Query For Table Comparison

Help Activities
, , ,
1

Hello Folks ,
I have a linq query for table comparison but i need to change a condition that there is column in which unit is given ,if unit is Kg divide qty1 by 1000 and compare

dt_data.AsEnumerable.All(Function(x)Not String.IsNullOrWhiteSpace(x(“Size code”).ToString) AndAlso CDbl(x(“qty2”)) <= CDbl(x(“qty1”)) )

2

Hi @Prateek_Gulab_Pathak ,

Could you maybe provide us with a Sample data that you are working on ? As there are some data adherences/format need to be cleared.

This way we would be able to suggest appropriate solutions faster.

3

Hi @Prateek_Gulab_Pathak

Try This

dt_data.AsEnumerable.All(Function(x) Not String.IsNullOrWhiteSpace(x(“Size code”).ToString) AndAlso _
CDbl(x(“qty2”)) <= If(x(“Unit”).ToString.Trim.ToUpper = “KG”, CDbl(x(“qty1”)) / 1000, CDbl(x(“qty1”))))

4

Hi,
you want to modify a LINQ query to include a condition where you compare qty2 to qty1 after adjusting qty1 based on the unit. If the unit is “Kg,” you need to divide qty1 by 1000 before making the comparison. you can try below LINQ query:

dt_data.AsEnumerable.All(Function(x) Not String.IsNullOrWhiteSpace(x("Size code").ToString) AndAlso 
                                       CDbl(x("qty2")) <= If(x("Unit").ToString = "Kg", CDbl(x("qty1")) / 1000, CDbl(x("qty1"))))

In this query, I’ve added a check for the unit (x("Unit").ToString = "Kg") and adjusted qty1 accordingly (CDbl(x("qty1")) / 1000). The If statement is used to conditionally divide qty1 by 1000 if the unit is “Kg”; otherwise, it leaves qty1 unchanged. The comparison is then made between qty2 and the adjusted qty1.

5

DT1
image

DT2
image

i have joined The Table And Compared The Data

@supermanPunch PFA

6

Thanks For The Solution

Cheers

7

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