how to replace NULL value as top most value in pivot table?

[#1]

Hi,

Can anyone suggest me how can I get the replaced NULL value as top most value in pivot table? please see attached. As I replaced the Null Values with 'Not Default UTD' . I would need this at the starting of the column values.

Thanks.

[#2]

Tried not working.

[SunilChauhan]

hi use your field in pplace in wildmatch

there is typo

[#4]

sorry I confused here. the field which I have is AgeSummary_March. please explain a bit more

[SunilChauhan]

use wildmatch(AgeSummary_March,Null()) in sort expression

the sort order asc or desc from dropdown available

or wildmatch(AgeSummary_March,' ') then sort order asc or dsc

hope this helps

[#6]

It sounds like it cant find the file you are trying to load

[#7]

Is this correct which I am using?

Map1:

MAPPING LOAD * INLINE [

AgeSummary_March,SortOrder

'',1
1 Month,2

1Month,3
2month,4
3months,5
4months,6
5months,7
6months,8
7-11months,9
12months+,10
];

LOAD AgeSummary_March,

     ApplyMap('Map1',AgeSummary_March,10) AS SortOrder

   
FROM Map1;

[#8]

Map1:

MAPPING LOAD * INLINE [

AgeSummary_March,SortOrder

"1 Month",2

"1Month",3
"2month",4
"3months",5
"4months",6
"5months",7
"6months",8
"27-11months",9
"12months+",10
];

Table1:

LOAD AgeSummary_March,

ApplyMap('Map1',AgeSummary_March,1) AS SortOrder

FROM ;

[sudeepkm]

Is it possible to post the sample qvw you have?

[#10]

Thanks. The script is executing. But when I use 'SortOrder' in sort expression it is not showing 'Not Default UTD' in top. Do I need to change anything here?

[eduardo_sommer · Accepted solution]

There is a simple way to do this. Before you load the main table, include the inline load below:

Labels:

Load * INLINE [

AgeSummary_March

Not Default UTD

1Month

1month

2months

3months

4months

5months

6months

7-11monts

12months+

];

It's importante that the name of the column, and the labels are exactly the same as in your table.

In the pivot table (order tab) choose input order. Since the inline load is executed before the load of your table, it will determine the input order.

Let me know if this worked for you.