topic Re: Separating each symbol in string in QlikView

Separating each symbol in string

Anonymous — Thu, 30 Jun 2016 06:32:28 GMT

Colleagues, good day!

I have one field, which contain information about delivery days.

For example, if delivery days are Monday, Tuesday - value is MT.

Friday, Saturday- FS.

How i can convert such symbol combination into days concat.

Maybe, it's possible by concat function, which can read string per symbol?

Necessary result:

DelDays	Result by exp
F	Friday
T	Tuesdat
MW	Monday, Wednesday
Su	Sunday
MTWTh	Monday, Tuesday, Wednesday, Thursday

Re: Separating each symbol in string

amit_saini — Thu, 30 Jun 2016 06:44:34 GMT

Hi,

Try:

Load * Inline [

DelDays , Result

F, Friday

T, Tuesdat

MW ,"Monday, Wednesday"

Su ,Sunday

MTWTh, "Monday, Tuesday, Wednesday, Thursday"

];

Thanks,

Re: Separating each symbol in string

Anil_Babu_Samineni — Thu, 30 Jun 2016 06:55:47 GMT

Like This,

Make sure, You have List box you can write this expression in Expression Tab.

Hope Helpful...

=If(DelDays = 'F','Friday',

If(DelDays = 'T','Thursday',

If(DelDays = 'MW','Monday, Wednesday',

If(DelDays = 'SU','Sunday',

If(DelDays = 'MTWT','Monday, Tuesday, Wednesday, Thursday',)

)

Re: Separating each symbol in string

Thu, 30 Jun 2016 07:23:42 GMT

Use a if() to create the field is possible to do the outcome FYR:Creating a new field with IF statement Hope It helps!

Re: Separating each symbol in string

Kushal_Chawda — Thu, 30 Jun 2016 07:44:54 GMT

see this

Directory;

LOAD *,

Pick(match(DelDays,'F','MTWT','MW','Su','T'),'Friday','Monday, Tuesday, Wednesday, Thursday','Monday, Wednesday','Sunday','Tuesday') as Days;

LOAD DelDays

FROM

Test.xlsx

(ooxml, embedded labels, table is Лист1);

Re: Separating each symbol in string

Anonymous — Thu, 30 Jun 2016 13:17:47 GMT

Thanks.

But i mean some automatic checking by these symbol combination.

I have more than 60 such combination and i need write condition for each of them (count of these conditions can grow)

Re: Separating each symbol in string

Kushal_Chawda — Thu, 30 Jun 2016 13:21:19 GMT

I think mine answer is not helpful

Re: Separating each symbol in string

sunny_talwar — Thu, 30 Jun 2016 13:31:02 GMT

Nai yaar... esa nai hai... bahut helpful hai

Re: Separating each symbol in string

Anil_Babu_Samineni — Thu, 30 Jun 2016 13:36:06 GMT

Kushal,

Not like that, What ever poster expecting we are giving the solutions. He didn't release any thing about what he is looking.

Meantime, That is not a problem - Whoever poster he just release BTA. If he tell something hints then we can try.

- Anil Chowdary

Re: Separating each symbol in string

tamilarasu — Thu, 30 Jun 2016 13:49:00 GMT

You can use MapSubString in that case. Try this,

Map:
 Mapping LOAD * INLINE [
 Short, Full
 M, ", Monday"
 T, ", Tuesday"
 W, ", Wednesday"
 Th, ", Thursday"
 F, ", Friday"
 S, ", Saturday"
 Su, ", Sunday"
 ];
 
 Tab:
 LOAD DelDays, Mid(MapSubString('Map',DelDays),3) as Result
 INLINE [
 DelDays
 F
 T
 MW
 Su
 MTWTh
 ];

Re: Separating each symbol in string

Kushal_Chawda — Thu, 30 Jun 2016 16:57:39 GMT

sunny bhai maje le raha he tu