Check 2 same values are present but they are negative and positive BUT how should i get the value which doesn't have its counterpart?

Help
, ,
21

@AshwinS2

I am not trying to change it, I am trying to retrieve that value.

Well, I think I got an Idea using @supermanPunch 's solution, Let me try that, I think it might work.

Thanks. Please continue to post your ideas and solution. It might help me and others

thanks
Aryan

1 Like
22

@supermanPunch

I have found a way I guess, can you help me separate the only positive and only negative row in two separate datatables?

right now its coming like this:

image

But I need all the columns in the 2 DTs like below:

image
image1299×126 6.9 KB

Thanks
Aryan

23

@AryanSingh Does your Excel File have a Fixed Format always, or does it keep Changing ? :sweat_smile:

24

@supermanPunch

Its fixed!

25

@AryanSingh Ok Then Can you provide the Final Fixed format Excel File that you are going to use in your Scenario

26

@supermanPunch

This is the one. Please check.

Thanks
Aryan

27

@AryanSingh What is the Format of the Output File?

28

@supermanPunch

same. we just have to separate the positive values and the negative values!

29

@AryanSingh Then the Output will be two Datatables?

30

@supermanPunch

Yes brother. I have changed my approach. Since, I was not able to use the previous one.

31

@AryanSingh Can you give an Example Output for that Input file, I’m Sorry for repeated questions, but i want it to be clear :sweat_smile:

32

@supermanPunch

For positive:

image
image1299×80 4.65 KB

For negative:

image
image1297×95 5.55 KB

Hope this clears your query.

Thanks
aryan

33

@AryanSingh Check this SplitDatatableAndCheck.zip (21.9 KB)

2 Likes
34

@supermanPunch

Just want to confirm one thing, it will work even if there are only single type of values?

Like either positive or negative!

Thanks

35

@AryanSingh Like if Only Positive values are present?

36

@supermanPunch

Yes!

37

@AryanSingh If there are no rows with Positive values it will result in an Empty Table

1 Like
38

@AryanSingh Just experiment it with all cases :sweat_smile:

1 Like
39

Thanx… its solved.

2 Likes
40

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