topic Re: Fieldvalue conversion in Qlik Learning Discussions

Fieldvalue conversion

rahulsud007 — Fri, 13 Mar 2015 16:06:23 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: Fieldvalue conversion

MK_QSL — Fri, 13 Mar 2015 17:23:07 GMT

T1:

Load *, Len(Month) as Length Inline

[

D, Month

AK, 10101

AJ, 11111

];

T2:

Load

Mid(Month,IterNo(),1) as Month

Resident T1

While IterNo() <= Length;

Drop table T1;

Re: Fieldvalue conversion

rahulsud007 — Fri, 13 Mar 2015 19:42:33 GMT

Hi Manish, thanks for your reply. But here i am getting the result as but I need out put as

AK 1 and

AK 0

AK 1

Ak 0

AK 1

AJ 1

Re: Fieldvalue conversion

maxgro — Fri, 13 Mar 2015 20:00:35 GMT

add an id in load, you can use it in straight table chart and hide

T2:

Load

rowno() as id,

Mid(Month,IterNo(),1) as Month

Resident T1

While IterNo() <= Length;

Drop table T1;

Re: Fieldvalue conversion

rahulsud007 — Sat, 14 Mar 2015 05:44:30 GMT

Hi Massimo, its not working as required. If u are getting it appropriately as I mentioned please share the Qvw.

Re: Fieldvalue conversion

Sat, 14 Mar 2015 07:52:07 GMT

Hi Rahul S,

As Massimo said it works just fine. I tried it on my machine.

Re: Fieldvalue conversion

maxgro — Sat, 14 Mar 2015 08:16:59 GMT

PFA

Re: Fieldvalue conversion

rahulsud007 — Sat, 14 Mar 2015 10:52:51 GMT

Hi Massimo,

It worked, thanks a lot.

Re: Fieldvalue conversion

MK_QSL — Sat, 14 Mar 2015 11:14:18 GMT

When I worked on your question, i used IterNo() as id while iteration.. but by mistake has removed while uploading answer..

Re: Fieldvalue conversion

rahulsud007 — Sat, 14 Mar 2015 11:16:42 GMT

Thanks Manish, for your support.

Re: Fieldvalue conversion

rahulsud007 — Mon, 16 Mar 2015 14:02:34 GMT

Hi guys, thanks for your support till now! Now here I have attached two more field named Month1 and Month2 along with Month.

But when I represent the data in Table Box I am getting blank spaces for Month and Month2 because its value is less than that of Month1. I want to suppress those blank spaces and I need it in table box so the editing should be done in script. Can you guys help me in it?

Please check the attachment.

Thank you!