Need to combine data from 2 fileds

[ramyasaiqv]

Hi All,

I have 2 different fields most of the values for these two fields are same except one or 2 values.

Even though the two field values differ one value is "local" and another value is "Sports Local" they basically represent the same value. So my requirement is i want to combine these two fields into one and make the values uniform.

Attached are the excels with the sample and expected results.

Thank you,

Ramya

Message was edited by: Ramya Sai Sorry i have attached a wrong data files. So corrected it and updated the the correct data files. Sorry about it. Thank you, Ramya

[rahulpawarb]

Hello Ramya,

Could you please elaborate more on which two fields you want consolidate by providing some example? This will help us to provide expected response.

Regards!
Rahul

[ahaahaaha]

Hi Ramya,

Rahul rights, we as a community of Qlik really want to help you. Three your attachments file resulted in one (the attached file xlsx).

I ask you to clarify once again, if I understand you correctly:

1.How do you want to process the field "NAME" and "LINE" to attach the table?

2. That must be obtained as a result?

Regards,

Andrey

[ramyasaiqv]

Hi Andrey,

Thank you for the response. I'm sorry actually i attached wrong data files. I have updated the files now

Basically i have 2 tables "Group Name" and "Name" with almost similar values except one value (Local and Sport Local).But even though they are different in description (Local and Sport Local) they represent the same i.e Local. So the requirement is how to make these 2 fields (Group Name" and "Name) as one. In the resulting table "Sport Local "should be replace by ""Local. Please let me know if that makes sense. Thank you,

Ramya

[ecolomer]

In the script, when reading the field, you can stay with "Local" in both cases

[ramyasaiqv]

Hi Rahul,

Thank you very much for the response. Sorry for the delayed response, i wanted to combine "Group Name" and "Name" fields. These 2 fields have one different value(Local and Sport Local). But in the resulting field i want to Replace Sport Local with Local. Thank you,

Ramya

[ecolomer]

In the script:

if ([Group Name]='Sport Local', 'Local', [Group Local]) as Name

[ramyasaiqv]

Hi Enrique,

Thank you for the response, i'm sorry i didn't get that please can you explain it  little bit more.

[ecolomer]

The script:

Name:

LOAD

  Name

FROM

(ooxml, embedded labels, table is Sheet1);

GName:

LOAD

  [Group Name]

FROM

(ooxml, embedded labels, table is Sheet1);

New:

LOAD

  if(Name='Sports Local', 'Local', Name) as New_Name

FROM

(ooxml, embedded labels, table is Sheet1);

[ahaahaaha]

Only yesterday discussed a similar topic (Group by a column based on fuzzy match). It seems that the trend analiz "fuzzy sets" on the letters / words the level (or rather the use of Qlik for this purpose) becomes relevant. The good news, but I repeat my position today.

Any language is redundant. Restore the meaning of the text by fragments of words and even individual words possible.

However, when it comes to the key fields, it seems to me, the use of fuzzy generalization method is not correct.

Regards,

Andrey