Displaying data by Filtering the data using same column without using any Filter Pane.

[sanjaya9203]

Hi Friends,

Need your help. I stuck up with the following situation. Please go through the Attachment for the the Input data and the Expected output.

		Expected Output
Material No.	Class	Char Name	Char Value	Mail ID
0161-2857	ABC_BRIDGE	ABC_CROSS_PLANT_STAT_CD	XXX	NAME1@XYZ.COM
0161-2859	ABC_BRIDGE	ABC_CROSS_PLANT_STAT_CD	XXX	NAME1@XYZ.COM
0161-2860	ABC_BRIDGE	ABC_"="""036"_CD	XXX	NAME1@XYZ.COM
13599700	ABC_BRIDGE	ABC_MATERIAL_GROUP_CD	XXX	NAME2@XYZ.COM
13599700	ABC_BRIDGE	ABC_MATERIAL_TYPE_CD	XXX	NAME2@XYZ.COM

In my data there are column name as mentioned in the above table. I need the above the based on the following condition.

1.check for the Class = ABC_BRIDGE,

2. check   if Char Name=ABC_RELEVANCY and  Char Value=Y,   then check any Char value like XXX present or not.

3. If no XXX then it's OK, Else Populate the XXX in the report as per above table.

4. populate the mail id's  those whose Char Value ='XXX',  

5. The mail ID can be obtained based on the ABC_REQUESTER_ID. that means 

if([Char Name]='ABC_REQUESTER_ID', [Char Value])

I tried in different approach by doing aggregating of different column, but i failed and i am getting null value for the Email ID column. Please help me in this regard.

Thank you in advance.

Sanjay

[lironbaram · Accepted solution]

hi 

assuming you use this for the Char Value column 

if(Class='ABC_BRIDGE' and [Char Value]='XXX',[Char Value])

you can use this for the e-mail 

if(len(if(Class='ABC_BRIDGE' and [Char Value]='XXX',[Char Value]))>1,
MaxString(total <[Material No.]> if([Char Name]='ABC_REQUESTER_ID',[Char Value],0)),0)

but you probably should find the email address for each material no. in the script , and than add it to the table as a field , 

to make your expressions easier 

[sanjaya9203]

Thank you lironbaram Very much for your help. I did as per your suggestion and achieved the required output.

Thank you,

Sanjaya