topic Re: Two tables field value to check in QlikView

Two tables field value to check

chiragngohel — Mon, 21 Mar 2016 16:08:19 GMT

Hi,

Can someone help me please?

I am trying to compare two file fields value with same field name(comparison for two months) in script.

Can some one suggest best way? Is it possible?

FOR i = 1 to NoOfFields('T')
Concatenate

Fields:

LOAD

// FieldName($(i),'New') as FieldName
FieldName($(i),'T') as F,
FieldValue($(i),'T') as v,
//FieldValue(FieldName($(i),'T')) as F2,
//if(FieldName like FieldName($(i),'New') and FieldValue=FieldValue,'Match','Others') as t2,
if(WildMatch(FieldName($(i),'T'), FieldName($(i),'T2')),'Match','Other') as f1,
if(Match(FieldValue($(i),'T'),FieldValue($(i),'T2')),'Match','Other') as f3

AutoGenerate 1

;
NEXT I

Re: Two tables field value to check

chiragngohel — Mon, 21 Mar 2016 16:10:06 GMT

I tried field value but it is not working.

Re: Two tables field value to check

settu_periasamy — Tue, 22 Mar 2016 03:24:34 GMT

Hi,

I think your script seems to be fine for me. May be you can try to change the "Next i" ( In your code shows capital letter "I" - I believe this is not a typo)

FOR i = 1 to NoOfFields('T')
Concatenate

Fields:

LOAD

// FieldName($(i),'New') as FieldName
FieldName($(i),'T') as F,
FieldValue($(i),'T') as v,
//FieldValue(FieldName($(i),'T')) as F2,
//if(FieldName like FieldName($(i),'New') and FieldValue=FieldValue,'Match','Others') as t2,
if(WildMatch(FieldName($(i),'T'), FieldName($(i),'T2')),'Match','Other') as f1,
if(Match(FieldValue($(i),'T'),FieldValue($(i),'T2')),'Match','Other') as f3

AutoGenerate 1;

NEXT i

Re: Two tables field value to check

jagan — Tue, 22 Mar 2016 03:36:49 GMT

Hi,

As suggested by settu_periasamy change NEXT I to NEXT i.

Qlikview is Case sensitive Capital I and Small i is not the same.

Regards,

jagan.

Re: Two tables field value to check

chiragngohel — Wed, 13 Apr 2016 11:34:32 GMT

I cannot see capital "I" in my script. I am using only "i".

Re: Two tables field value to check

chiragngohel — Wed, 13 Apr 2016 11:39:00 GMT

That is already small i.

Re: Two tables field value to check

settu_periasamy — Wed, 13 Apr 2016 15:56:23 GMT

Copy your posted Script (In the first post), then check, it shows capital Letter 'I'.

See this..

Re: Two tables field value to check

chiragngohel — Wed, 13 Apr 2016 15:58:40 GMT

not I any more.

Re: Two tables field value to check

chiragngohel — Wed, 13 Apr 2016 16:00:07 GMT

T:
LOAD Name,
total,
'table' as type
FROM

(ooxml, embedded labels, table is Sheet1);
//Concatenate(T)

QUALIFY *;
UNQUALIFY Name;
//left join(T)
T2:
LOAD Name,
total,
'table2' as type
FROM

(ooxml, embedded labels, table is Sheet1);

//
UNQUALIFY *;

Re: Two tables field value to check

chiragngohel — Wed, 13 Apr 2016 16:02:31 GMT

Name	total
a	20
b	20
c	30
d	50

Re: Two tables field value to check

chiragngohel — Wed, 13 Apr 2016 16:06:52 GMT

Name	total
a	20
b	30
c	40
d	50

Re: Two tables field value to check

chiragngohel — Wed, 13 Apr 2016 16:07:44 GMT

these are the two tables I am trying to compare the fields name and its value.

I hope it make sense now.

Re: Two tables field value to check

settu_periasamy — Wed, 13 Apr 2016 16:39:34 GMT

That is fine. Can you give the expected result?