topic Re: Get only common value in the field in QlikView

Get only common value in the field

karan_kn — Thu, 19 Apr 2018 13:04:16 GMT

Can someone help me to pick common value and create new field in load statement

EX:

account1=account2

Account1	Acount 2	NewField
1	1	1
2	3	3
3	5
4	7

Re: Get only common value in the field

sunny_talwar — Thu, 19 Apr 2018 13:06:19 GMT

How did you get 3 for row number 2 under NewField? In row 2 Account1 <> Account2

Re: Get only common value in the field

karan_kn — Thu, 19 Apr 2018 13:11:11 GMT

compare two fields and get common values only

Ex: 1 and 3 values only common

Re: Get only common value in the field

karan_kn — Thu, 19 Apr 2018 13:33:17 GMT

looking like this:

if(Account1=Account2) as new field

Re: Get only common value in the field

max_potass — Thu, 19 Apr 2018 15:02:51 GMT

If(Account1 = Account2, Account1) as NewField

Re: Get only common value in the field

shaileshs — Thu, 19 Apr 2018 16:05:46 GMT

Here is a concept that might get desired results but i wouldnt recommend this on huge data set. You would have to evaluate if this fits your needs, i have separated columns and loaded them in two different tables , and looked up values, Its a simple script so hopefully not much of explanation needed here

Here is info on lookup function:

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/InterRecordFunctions/LookUp.htm

Accounts:

Load * Inline [

Account1

] (delimiter is '|');

Accounts2:

Load *, Lookup('Account1', 'Account1', Account2 , 'Accounts') as NewField

Inline [

Account2

] (delimiter is '|');

Let me know what you think.

Re: Get only common value in the field

shaileshs — Thu, 26 Apr 2018 18:05:36 GMT

Hi Karen,

Does this answer your question?

Thanks,