Merge two values

[Anonymous]

Hi,

I need to mege two values which are existing in the same field but in last both names are different.

For example:

MyField: These values are coming in the list box

Current Output:

ABC-CDE

ABC-CDEFG

Required Output:

Required output

ABC-CDE

Both should be merge by using great method. Such as using wildmatch etc.

Note: Some times these values are greater then 7 digit

For Example: Current scenario

XYZ-AB-001

XYZ-AB-001-C1

Requried scenario:

XYZ-AB-001

Therefore, I need a method which run in all the scenarios.

regards,

[maxgro · Accepted solution]

maybe changing the b load only, difference with previous script posted is in bold

Sales:

LOAD field, value, len(field) as len

FROM Sales.xlsx (ooxml, embedded labels, table is Sheet1);

b:

load

  field,

  len,

  value,

  if(wildmatch(field, peek(fieldgroup) & '*') and len(peek(field))>0, peek(fieldgroup), field) as fieldgroup

Resident Sales

order by field, len;

DROP Table Sales;

c:

load

  fieldgroup as field,

  sum(value) as value

Resident b

group by fieldgroup;

drop table b;

[Anonymous]

Hi Massimo,

Great work, Congratulation! You did this.

I'm specially thankful to you with bundle of thanks.

I have no words to express my happiness.

I hope, you will help us in future.

You putted your valuable efforts to help me, to come out from this problem.

Again, many thanks to you.

Many thanks and kind regards,

Eng

[engishfaque]

Dear Massimo,

I'm trying to remove some sort of values using this thread, but facing an issue.

Please have a look to this thread, and advise me

Remove duplication and sum value

Kind regards,

Ishfaque Ahmed

[engishfaque]

Dear All,

This script is working fine.

if(wildmatch(SKU,  peek(fieldgroup)& '*') and len(peek(SKU))>0, peek(fieldgroup), SKU) as fieldgroup

Remove duplication and sum value

Kind regards,

Ishfaque Ahmed