on 01-08-2015 10:03 AM
Hi All,
I have a requirement to change the already existing Z info set like below:
Scenario:
My Infoset is having 1 base DSO (i.e. BD1) connected with 7 different DSOs (i.e. D1,D2...D7) via left outer join. Now my requirement is to connect a master data table (M1) with Inner join based on some filteration criteria (S2, S3, S5).
For Ex: In M1, there is a field "status" which has values as S1,S2...S9 with primary key as PK1 which is also Primary key for the Base DSO BD1.
for few PK1, earlier status was S1, S2.. but now the status got changed.
Requirement:
Now I want to show the data in the query which should not have S2, S3 and S5 status.
Inputs invited.
Thanks in advance !!
Regards,
Niranjan
Hi Niranjan,
Add M1 to the InfoSet joining it to BD1 on the primary key ( PK1 from M1 = PK1 from BD1 ). Join should be inner join so that the filter works.
Add conditions on status field of M1 to filter out rows when status is S2, S3 or S5
Regards,
Fernando
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you try to use conditions?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.