topic Re: Compare fields and assign values in QlikView

Compare fields and assign values

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

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.

Re: Compare fields and assign values

Anil_Babu_Samineni — Tue, 02 May 2017 07:38:00 GMT

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

Re: Compare fields and assign values

mromrod22 — Tue, 02 May 2017 07:42:29 GMT

Yes, I know.

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

Re: Compare fields and assign values

Anil_Babu_Samineni — Tue, 02 May 2017 07:45:18 GMT

Try to use Table box for that

Re: Compare fields and assign values

mromrod22 — Tue, 02 May 2017 07:49:00 GMT

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

Re: Compare fields and assign values

prieper — Tue, 02 May 2017 08:33:38 GMT

.... 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

Re: Compare fields and assign values

mromrod22 — Tue, 02 May 2017 09:03:25 GMT

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.

Re: Compare fields and assign values

Anil_Babu_Samineni — Tue, 02 May 2017 09:14:20 GMT

Can you provide excel

Re: Compare fields and assign values

prieper — Tue, 02 May 2017 09:20:07 GMT

what is the keyfield in your data?