I need output some thing like this x1,x2,x3....xn

[Anonymous]

I need output some thing like this x1,x2,x3....xn

thanks

[#2]

Please provide some sample of ur data.

[syukyo_zhu]

can you explain more your request?

[Anonymous]

suppose i have months jan to dec ,now i would like name them as X1,x2..x12

Thanks

[amit_saini]

Hi,

You can do like this in your script:

LOAD *

pick( WildMatch(Your_Field ,'*Jan*','*Feb*','*March*'),'X1','X2','X3')

From

Thanks,

AS

[amit_saini]

Check this :

http://community.qlik.com/message/682636#682636

Thanks,
AS

[syukyo_zhu]

you can use mapping load + applymap.

MappingCalendor:

Mapping

LOAD * INLINE [

    month, newname

    jan, x1

    feb, x2

    .....

];

load

ApplyMap('MappingCalendor', Field,null() as Newname

....,

from

xxxx

[PrashantSangle]

Hi,

Create inline table

try like

load * Inline [

Month , NewField

jan,x1

feb,x2

mar,x3

apr,x4

may,x5

jun,x6

jul,x7

aug,x8

sept,x9

oct,x10

nov,x11

dec,x12

];

Regards

[Anonymous]

of course thats a good idea but if we have 100's of records to change its a time consuming right .Can we make it with the autonumber ?

[#10]

him

You can create and inline using months name

LOAD * INLINE [
     your month field name, your required field name
Jan, x1
Feb, x2
Mar, x3
Apr, x4
May, x5
Jun, x6
Jul, x7
Aug, x8
     likewise
];