topic Creating key field in QlikView

Creating key field

Anonymous — Thu, 17 Sep 2015 10:13:37 GMT

If I have a list of supplier numbers and a list of customer numbers how can I create a key field which combines the two for every combination?

Supplier

123

456

789

Customer

987

654

321

results in a table like this

CustSupp

987-123

987-456

987-789

654-123

654-456

654-789

321-123

321-456

321-789

Thanks

Re: Creating key field

alexandros17 — Thu, 17 Sep 2015 10:28:48 GMT

Join the 2 sets of data then the rusult will be a table with 2 fields, reload it with a third field doing:

Load Field1 & '-' Field2 resident Table;

Re: Creating key field

marcus_sommer — Thu, 17 Sep 2015 10:36:44 GMT

If this is only for a key you should use this from Alexandros17 suggested field-joining within an autonumber:

Load *, autonumber(Field1 & '-' Field2) as Key resident Table;

- Marcus

Re: Creating key field

sasiparupudi1 — Thu, 17 Sep 2015 10:50:23 GMT

Try

Supplier&'-'&Customer as CustSupp

Re: Creating key field

maxgro — Thu, 17 Sep 2015 11:52:42 GMT

Supplier:

load * inline [

Supp

123

456

789

];

Customer:

load * inline [

Cust

987

654

321

];

TmpCustSupp:

NoConcatenate load Supp Resident Supplier;

join (TmpCustSupp) load Cust Resident Customer;

CustSupp:

load

Cust & '-' & Supp as CustSupp

Resident TmpCustSupp;

DROP Table TmpCustSupp;