topic Re: Loading Manual fields and connect in QlikView

Loading Manual fields and connect

Anonymous — Wed, 28 May 2014 13:39:27 GMT

Dear Experts,

I need your help in the below task.

I have a field which is in the below format.

AAA1|AAA2|AAA3

AAA2|AAA1|AAA3|AAA4

AAA4|AAA3|AAA1

I want to create a manual field like below

AAA1

AAA2

AAA3

AAA4

and then when I select AAA1 it should select my original field.

Kindly help

Thanks & Regards

Jeba

Re: Loading Manual fields and connect

ashfaq_haseeb — Wed, 28 May 2014 13:44:08 GMT

Hi,

like this

load * ,left(Field,4) as NewField;

LOAD * Inline

[

Field

AAA1|AAA2|AAA3

AAA2|AAA1|AAA3|AAA4

AAA4|AAA3|AAA1

];

Regards

ASHFAQ

Re: Loading Manual fields and connect

Anonymous — Wed, 28 May 2014 13:46:53 GMT

Jeba,

If I got your question right, this should work:

data:
load * inline [
OriginalField
AAA1|AAA2|AAA3
AAA2|AAA1|AAA3|AAA4
AAA4|AAA3|AAA1
];

New:
load distinct
OriginalField,
subfield(OriginalField, '|') as NewFeild
resident data;

Regards,

Michael

Re: Loading Manual fields and connect

Anonymous — Wed, 28 May 2014 13:47:51 GMT

Hi Ashfaq,

Thanks for the message.

However my field length is not fixed.The only delimiter is |

Also I have one more clarification in the Inline statement.

My database has many fields including the one which I want to filter.

still shall I use Inline?

Regards

Jeba

Re: Loading Manual fields and connect

ashfaq_haseeb — Wed, 28 May 2014 13:53:40 GMT

Hi,

If it is not fixed, then use below code shown for NewField1.

load * ,left(Field,4) as NewField,

Left(Field, Index(Field, '|') - 1) as NewField1;

LOAD * Inline

[

Field

AAA1|AAA2|AAA3

AAA2|AAA1|AAA3|AAA4

AAA4|AAA3|AAA1

];

Yo can apply the same while loading from database.

Regards

ASHFAQ

Re: Loading Manual fields and connect

Anonymous — Wed, 28 May 2014 13:58:11 GMT

Hi Michael,

Thanks for the help.

Your logic is correct.Since I have many fields in my table do I need to write a separate inline statement exclusively for this field and also the fields are not fixed.It can be a any type of combination but we have a delimiter |

Actually this is separate requirement which I just received from my requestor.

I build everything properly,but matching this by a new field is where I struck up.

Kindly help

Thanks & Regards

Jeba

Re: Loading Manual fields and connect

ashfaq_haseeb — Wed, 28 May 2014 14:01:07 GMT

Hi if you solution is what Michael suggest.

No need to worry about length.

you can create separate field while loading from database itself.

Regards

ASHFAQ

Re: Loading Manual fields and connect

Anonymous — Wed, 28 May 2014 14:05:43 GMT

No need for load inline. If your have your OriginalField loaded form the database or any data source, only the seconf part is relevant. The essence of the solution is the subfield() function which breaks the OriginalField intothe separate parts.

Re: Loading Manual fields and connect

Anonymous — Wed, 28 May 2014 14:10:40 GMT

Hi Michael,

Thanks a lot

It worked.

Thanks & Regards

Jeba