Split one column data into multiple columns in WEBI Repot

[Former Member]

Hi All,

Can you please help me with below reporting issue?

I have a data in my table as below

Object Name	Event StartTime	Prompt Name	Prompt Value
Test Report	9/12/2014 16:35	Enter value(s) for Package Classification Detail:
Test Report	9/12/2014 16:35	Enter value(s) for Package Status:
Test Report	9/12/2014 16:35		Infrastructure
Test Report	9/12/2014 16:35		Open/Approved

I need to disaply in Below Format

Object Name	Event StartTime	Prompt Name	Prompt Value
Test Report	9/12/2014 16:35	Enter value(s) for Package Classification Detail:	Infrastructure
Test Report	9/12/2014 16:35	Enter value(s) for Package Status:	Open/Approved

Here Both Prompt name and Prompt value are from Same object in query . I have created seperate veriable by using Where operator.

I dont want to create any dervied table /objects at universe to achive this. i want to do it at report layer...

Any help would be appreciated.

Thanks in advance

[Former Member]

Hi Jagadish,

Is there any other column in table to identify which prompt text belongs to which text.

~Anuj

[Former Member]

No such column which identify which prompt belong to which text..

I have tried with your formula , but its not solving the purpose

[jyothirmayee_s]

Hi,

Seems like Prompt name has null values for some rows.

You can do by filter Prompt name is null or even write a formula.

Also, Can apply break on Object name but check if Prompt names has any null values.

Thanks,

Jothi

[Former Member]

Jyoti, prompt has no null values.

Actually, im trying to show Reportname, report promt text, promt value through audit.

Event Detail value Stores the  data for both ptompt text and promt values in aduit table for Event Detail Type is "prompt name an prompt value"

Prompt Name= =[Event Detail Value] Where([Event Detail Type]="Prompt Name")

Promt Value== =[Event Detail Value] Where([Event Detail Type]="Prompt Value)

Data looks as below in table when i use the above two variables

Object Name	Event StartTime	Event Detail Type	Prompt Name	Prompt Value
Test Report	9/12/2014 16:35	Prompt Name	Enter value(s) for Package Classification Detail:
Test Report	9/12/2014 16:35	Prompt Name	Enter value(s) for Package Status:
Test Report	9/12/2014 16:35	Prompt Value		Infrastructure
Test Report	9/12/2014 16:35	Prompt Value		Open/Approved
Test Report	9/22/2014 18:29	Prompt Name	Enter value(s) for Package Classification Detail:
Test Report	9/22/2014 18:29	Prompt Name	Enter value(s) for Package Status:
Test Report	9/22/2014 18:29	Prompt Value		Infrastructure
Test Report	9/22/2014 18:29	Prompt Value		New
Test Report	9/22/2014 18:29	Prompt Value		Open/Approved
Test Report	9/22/2014 18:29	Prompt Value		Pending Funding Approval

We want to see data as below

Object Name	Event StartTime	Prompt Name	Prompt Value
Test Report	9/12/2014 16:35	Enter value(s) for Package Classification Detail:	Infrastructure
Test Report	9/12/2014 16:35	Enter value(s) for Package Status:	Open/Approved
Test Report	9/22/2014 18:29	Enter value(s) for Package Classification Detail:	Infrastructure
Test Report	9/22/2014 18:29	Enter value(s) for Package Status:	New
Test Report	9/22/2014 18:29	Enter value(s) for Package Status:	Open/Approved
Test Report	9/22/2014 18:29	Enter value(s) for Package Status:	Pending Funding Approval