Hi Experts,
I have below 2 tables tables and the fields common between both tables are-
Product, System, Location, BusinessArea. The row in yellow background is the only row common between both tables.
I will concatenate both tables.
Sales:
LOAD *,
'Sales' as DataSet
INLINE
[
Prouct, System, Location, BusinessArea, Sales,Date
AA, SAP, DE, Manufacturing, 67, 01/01/2017
AA, Oracle, US, IT, 80,05/01/2017
BB, SAP, UK, Accounting, 578, 08/01/2017
CC, IBM, IN, IT, 79, 13/01/2017
DD, MS, US, IT, 969, 18/01/2017
DD, IBM, US, Research, 89, 11/01/2017
];
Concatenate
Problems:
LOAD *,
'Problems' as DataSet
INLINE [
P_ID, Prouct, System, Location, BusinessArea
200, AA, PeopleSoft, US, Manufacturing
300, BB, SAP, UK, IT
400, CC, IBM, IN, IT
500, ZZ, Microsoft, FR, HR
];
My main requirement is to show Sales data in a straight table and its corresponding P_ID(may be in expression).
This above case i assume only P_ID- 400 will be shown in straight table as it is only row common between both tables.
However i want to display other P_ID's that are less common as well if a selection is made. What i mean is, if a user select Product- AA, then show P_ID - 200 along the below rows and similarly if System- SAP is selected by user, show P_ID- 300.
AA, SAP, DE, Manufacturing,
AA, Oracle, US, IT
I am not sure if straight table a good option for my requirement, but if there is better option, please guide me.
Thanks!
