Joining and concatenating

[#1]

I want to pull one single field into an existing table. Its bascially a description field.

Concatenation doesnt link the fields properly.

Using a Join Load, this creates lots of duplicates in my data.

Is there any other way in which to do it?

THanks

NOCONCATENATE LOAD
     @1 as PROD_HIER,
     @3 as PROD_HIER_DESC,
     @1 & ' - ' & @3 as g_groupc,
    
FROM table
WHERE len(@1)=10;

Join load
material_group_description as CatEDesc
resident material_group_text;

[swuehl]

brianm10,

since your field names are distinct, you will probably get a cross product between the tables, don't you?

I think you need to specify a field in your join load table which can be matched to the other table, something like CategoryID maybe, but this also needs to exist in the other table with same name (or renamed), so QV can match the field values.

Hope this helps,

Stefan

[#3]

Thanks for the reply.