Two tables field value to check

[chiragngohel]

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

[chiragngohel]

I tried field value but it is not working.

[settu_periasamy]

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

[jagan]

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.

[chiragngohel]

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

[chiragngohel]

That is already small i.

[settu_periasamy]

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

See this..

[chiragngohel]

not I any more.

[chiragngohel]

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 *;

[chiragngohel]

Name	total
a	20
b	20
c	30
d	50