Restricting values in dimension

[Anonymous]

Hi Team,

I am handling the Scenario as:

Table 1  

ABC	Order status
A	Pending
A	In progress
A	Completed
B	Completed
C	Completed
A	In progress
A	Pending

Table 2

ABC	Issuencetype
A	CMO
B	RP
A	CMO
B	C&S
C	AMR
A	CMO
A	CMO

I have two tables, now i am creating a new table with dimension by only values of 'A' from Table 1 and values of 'B' and 'C' from table 2.

By using column 'ABC' with respective filters i am combining Order Status and Issuencetype as new dimension.

Please provide your suggestions.

Regards,

Ashok Ravichandran

[Chanty4u]

is this?

map1:

mapping LOAD

ABC,

     OrderStatus,    

FROM

......tabl1

Result:

ABC,

     Issuencetype,
    applymap('map1', ABC,'Unknow')    as NewDimension
FROM
.....

[Anonymous]

Chanty,

Thanks for your comments,

Order status and Issuance type has different values, i need only A value from table 1 associated with Order status and table 2 associated with Issuance type as new dimension

[Neymar_Jr]

Hi,

Try this -

NewTable:

Noconcatenate

Load * resident Table1

where ABC = 'A';

concatenate

Load ABC

,Issuencetype as [Order status]

resident Table2

where ABC <> 'A';

Drop field Issuencetype from NewTable;

Thanks,

RT