count duplicated value in QVD

[#1]

Hello Experts,

I want to generate output variable in my qvd file, please help.

[#2]

Please try this as expression where ID and FID are dimensions in straight table:

=Left(aggr(Rank(FID),ID),1)

Thanks,

Angad

[#3]

Hi,

A Group By on Load should do.

Assuming you just wanna test this from you qvd file, and no null in ID:

CountTable:

LOAD ID, FID, count(ID) as Output

FROM Table.qvd(qvd)

Group By ID, FID

;

If you wanna load other data from the qvd, better do the Group By after on Resident table, it should be faster:

Table:

Load *

FROM Table.qvd(qvd)

;

Left join(Table)

LOAD ID, FID, count(ID) as Output

Resident Table

Group By ID, FID

;

Hope this helps

[whiteline · Accepted solution]

Left join(Table)

LOAD ID, FID, count(ID) as Output

Resident Table

Group By ID, FID

Otherwise you'll get 1 for each row.

[#5]

Thanks mate, appreciated your help!

[#6]

Thanks mate, appreciated your help!