Straight Table Query

[#1]

HI All,

i have the data loaded in straight table:

tcategory	ttaskname	tus	tuk	tas
BAU	abc		a	a
Project	efg	WIP	WIP	WIP
Project	sdf		WIP	WIP
Project	ghj		Pipeline	Pipeline
Project	cfghy		WIP	WIP
Project	asdret		WIP	WIP
BAU	fgh	a	a	a
BAU	Client/Portfolio Pricing	Pipeline
BAU	Client/Portfolio Pricing		a

and my expected result is as below:

tcategory	ttaskname	tus	tuk	tas
BAU	abc		a	a
Project	efg	WIP	WIP	WIP
Project	sdf		WIP	WIP
Project	ghj		Pipeline	Pipeline
Project	cfghy		WIP	WIP
Project	asdret		WIP	WIP
BAU	fgh	a	a	a
BAU	Client/Portfolio Pricing	Pipeline	a

please advise

thanks

Sukhwant

[Anil_Babu_Samineni]

Suppress null values from Presentation tab

I've taken dim - tcategory, ttaskname, tus

Expression -  If(Len(tuk)>0,tuk)

                   If(Len(tas)>0,tas)

Then Supress the data, You will get exactly what you required. PFA for Ref.

[Oleg_Troyansky]

If I understand your requirement correctly, you need to combine various values for the three last columns by Category and Task. In order to achieve that:

1. Use Category and Task as Dimensions

2. Use three Expressions with the following formula:

MaxString(tus)

MaxString(tuk)

MaxString(tas)

[#4]

Hi,

Please take a look at the attached qvw.

Is this what you need?

- Stan

[sunny_talwar]

In a table box or straight table? If you use a straight table with tcategory and ttaskname as dimension and other three as expression, it might workout for you