topic Re: Value conversion in QlikView

Value conversion

rahulsud007 — Sat, 14 Mar 2015 06:20:49 GMT

Hi guys, My input field is the following and

Input

ID	Month
Ak	10101
AJ	11111

I need output in following way. in

ID	Month
AK	1
AK	0
AK	1
AK	0
AK	1
AJ	1
aj	1
aj	1
aj	1
aj	1

Can anyone help me in this?

Re: Value conversion

anbu1984 — Sat, 14 Mar 2015 06:59:28 GMT

Load ID,Mid(Month,IterNo(),1) As Month While IterNo() <= Len(Month);

Load * Inline [

ID,Month

Ak,10101

AJ,11111 ];

Re: Value conversion

Sat, 14 Mar 2015 07:43:43 GMT

Hi Anbu,

I was just browsing through the community and found out this thread. I must say the soln. proposed by you is a good way to approach it. But if i display those values in a table box it is not showing the desired output. But the actual output is shown in Table viewer preview option. What is it i am doing wrong??

Re: Value conversion

its_anandrjs — Sat, 14 Mar 2015 08:38:14 GMT

Hi Sashi,

Try to load like this way i am extending anbu script and for viewing the values add Recno() function for check the values.

Temp1:

Load ID,Mid(Month,IterNo(),1) As Month While IterNo() <= Len(Month);

Load * Inline [

ID,Month

Ak,10101

AJ,11111 ];

LOAD

RecNo() as Key

Resident Temp1;

DROP Table Temp1;

Check the attached also

Regards

Anand

Re: Value conversion

maxgro — Sat, 14 Mar 2015 11:51:30 GMT

same question, already answered

Fieldvalue conversion