topic Re: Re: Issues in the Comparision of two fields ? in QlikView

Issues in the Comparision of two fields ?

Sun, 25 May 2014 15:06:02 GMT

Hi All,

I am new to Qlikview.

I have below questions.

Example :

I need to compare two fields - Field A and Field B.

Field A - Data - 0000012345

Field B - Data - 12345

I need to make it field field B in 10 digit formate - i need to append leading zero to make it 10 digit

so, I can compare two fields data.

I have use Num (12345,'0000000000') AS Field B.

when i have Load script output it shows in 10 digit.

But, when I have joins two fields - it does not joins based on data matching between two fields.

so, can you please guide me what would be the issue ?

does is because two fields have different data types ?

what would be data type of Num (12345,'0000000000') ?

any assistance would be greatly appreciated.

Thanks!.

Re: Issues in the Comparision of two fields ?

ashfaq_haseeb — Sun, 25 May 2014 15:35:21 GMT

Hi,

may be like this.

Regards

ASHFAQ

Re: Issues in the Comparision of two fields ?

Sun, 25 May 2014 15:37:12 GMT

can you please suggest me solution of this ?

Re: Issues in the Comparision of two fields ?

ashfaq_haseeb — Sun, 25 May 2014 15:45:43 GMT

Hi,

look at my attachment. It has solution in it.

Regards

ASHFAQ

Re: Issues in the Comparision of two fields ?

Sun, 25 May 2014 16:24:02 GMT

I am new to qlikview and new to this forum.

can you please guide me and provide me link of that thread or document ?

Appreciate your help.

Re: Issues in the Comparision of two fields ?

maxgro — Sun, 25 May 2014 16:41:18 GMT

try this

or post your qlikview document

// table with 0000012345

table1:

load * inline

[

f1,f2

0000012345,aaaaaaaa

0000067890,cccccccc

];

// table with 12345 with num function to change 12345 in 0000012345

table2:

load

num(f1, '0000000000') as f1,

f3;

load * inline

[

f1,f3

12345,bbbbbbbb

67890,cccccccc

];

// join table1 and table2

left join (table1) load * Resident table2;

drop Table table2;

Re: Re: Issues in the Comparision of two fields ?

ashfaq_haseeb — Sun, 25 May 2014 16:52:20 GMT

Hi,

go to edit script and write the below code.

table1:
load * Inline [
KEY,CODE
ABC,AB
DEF,DE
XYZ,XY
YYY,YY];





table2:
Join load * Inline [
KEY,FIELD1
ABC,G-H-G-H-G-A-B-AB-ABC
DEF,AB-AB-DE-EF
XYZ,ABC-XY-QYZ
YYY,TT];


tabfinal:
NoConcatenate load KEY,CODE,FIELD1, if(SubStringCount(FIELD1,CODE)>0,'PRESENT','ABSENT') as CODEFLAG Resident table1;


DROP Table table1;

Regards

ASHFAQ

Re: Issues in the Comparision of two fields ?

preminqlik — Sun, 25 May 2014 17:27:35 GMT

table1:

Load *,

AutoNumberHash128(FieldA) as Key

from path;

join

//table 2:

load *,

autonumberhash128(fieldB) as Key

from path;