How to load distinct value?

[posywang]

Hi,

I'd like to load only one row if it has same Project Code. That one row can be randomly picked from multiple rows. Is this something that can be easily done? Thanks. Sample QVW and source file are attached.

[Steveo250k]

Wow, while all responses are much appreciated, using a keyword for both a file name and a table name makes this example very hard to follow.  In effect you are saying load distinct into distinct from distinct.  Wow.

[Steveo250k]

While all responses are much appreciated, using a keyword for both a file name and a table name makes this example very hard to follow.  In effect you are saying load distinct into distinct from distinct.