topic Re: Compare String Fields in QlikView

Compare String Fields

katetsan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Communities,

Is there anyway to compare two string fields?

Here is the if statement I have wrote in scripts. I'm going to create a new field which compare two string fields, but the outcome isn't correct. Is there anyone could help it up?

if(Trim([Company Country])=Trim([Deliver-To Party Country]),'TRUE','FALSE') as [Country Check],

Re: Compare String Fields

YoussefBelloum — Tue, 27 Mar 2018 07:15:58 GMT

Hi,

can you attach some data ?

Re: Compare String Fields

sasiparupudi1 — Tue, 27 Mar 2018 07:26:46 GMT

Try wildmatch

if(Wildmatch(Trim([Company Country]),Trim([Deliver-To Party Country])),'TRUE','FALSE') as [Country Check]

Re: Compare String Fields

jonathandienst — Tue, 27 Mar 2018 07:42:54 GMT

Your syntax is correct, so you will need to be more specific about why this does not work and what you require. Are you looking for a case sensitive, case insensitive or fuzzy comparison?

Re: Compare String Fields

shiveshsingh — Tue, 27 Mar 2018 07:45:42 GMT

Syntax is correct, can you share sample data?

Re: Compare String Fields

katetsan — Tue, 27 Mar 2018 09:42:19 GMT

Experts,

I found that I might made a logical mistake in the script.

Originally I would like to create a new field which will compare two fields from different two tables.

Therefore, I create a temporary link table for inner joining the two tables.

That would be grateful to receive your suggestions of comparing two fields from two different two tables.

Re: Compare String Fields

sasiparupudi1 — Tue, 27 Mar 2018 09:43:46 GMT

Please close this thread

Re: Compare String Fields

PrashantSangle — Tue, 27 Mar 2018 10:01:30 GMT

If you want to create flag field before joining them. or there is no common key between them then try with lookup()

like.

Id:

LOAD * INLINE [

ID1

];

data:

LOAD ID2,Name,If(Lookup('ID1','ID1',ID2,'Id')>0,'True','False') as flag INLINE [

ID2, Name

1, a

2, b

3, c

4, d

6, e

7, f

];

Regards,