How to Differentiate the different list of values from a single table.

[#1]

Hi All,

          I have a one requirement, In a table it has two companies data with depid's, so i need to Differentiate the values based some good logic, like

1. i should not use where clause condition in application.( i mean no hard code thing in all tables where it needs).

2.  i got the solution like from creating a mapping table and put join, will give the proper records as per that mapping table.

But i need the solution like, what is the other best practive we should make and get the right values. Please find the attached excel file then it will give u all some idea, what i am expecting currently.

Regards,

Ravi.

[giakoum]

Hi Ravi.

we need a rule here. You know that 1 and 2 belong to a different company than 12,13 and 14. But how is QV supposed to know? Is it the length? Or something else?

BR, Ioannis

[#3]

Hi Loannnis,

                  Thanks for your reply, But here there is no specific length two charatcter or digits, the thing is, i am expecting the replies from you guys.

Regards,

Ravi.

[jaspal_icon]

Hi Ravi,

Based on Department_Id you can make one more inline table or excel which can have

Company_Id, and Depart_Id, Now which departments come under which company on behalf of that you have filter data, and then use some set analysis.

Loannis is Right need some Rule(Where, If, ) conditional things to make it differente list as you require.

Regards

Jaspal

[#5]

Hi Jaspal,

               Thanks for your reply, But i can't use set analysis in this case, because if i use then i need to mention in each expression either flag or some hardcode thing but which we should not do.

Regards,

Ravi.

[jaspal_icon]

Ravi,

As you written

2.  i got the solution like from creating a mapping table and put join, will give the proper records as per that mapping table.

This can work but again you will provide some rule here, that from department Id 1 to 12 under this category and that,

You have to provide some rule, category neither how you can differentiate them.

Example:

Product_ID, Product_Name,Category_Id

1, Mobile X-2,1

2,  LCD-32,1

3,  Pepsi-250,2

Category_ID, Category_Name

1,Elctronics

2,Consumer Goods