Compare fields and assign values

[mromrod22]

Hi community!

I need your help in a issue. Explain me:

I have a table with duplicate rows:

In this example, I must show only one row, but show three for fields indicated in red. The correct output is:

I need assign null value to the fields indicated when find rows duplicated for this fields and update the number of rows.

Any idea? Thanks.

[Anil_Babu_Samineni]

Because, you have different equipo, description, marca and modelo values.

[mromrod22]

Yes, I know.

But the information real is being repeated. I need convert the first image in second image.

[Anil_Babu_Samineni]

Try to use Table box for that

[mromrod22]

This issue must be solved in script. Is not a design problem.

[prieper]

.... and what for do you need then the fields "marca" and "modelo"?

what is supposed to happen, if there are different fieldcontents in the other fields?

anyway and with aircode:

LOAD DISTINCT Field1, Field2, Field2....., NULL() as marca, NULL() as modelo FROM ....;

HTH Peter

[mromrod22]

So the client wishes...

Your LOAD not works but the table have 6500 rows, when someone is a unique row and others are few rows duplicates. In your LOAD can´t filter by equals dynamic fields.

[Anil_Babu_Samineni]

Can you provide excel

[prieper]

what is the keyfield in your data?