topic Re: Error unique fields, combine/merge two fields into one in QlikView

Error unique fields, combine/merge two fields into one

Fri, 17 Oct 2014 08:40:59 GMT

Can enyone help me?

When I load a specific table I get an error that says I have to use unique fields. I looked at my load statement and indeed found two fields with the samen name. The fields I load holds ID-numbers of suppliers and customers. I want them loaded in the same column called custSupID.

Example of the script I use now:

customerSupplier:

LOAD

[<bseg>-kunnr] as depSupID,

[<bseg>-lifnr] as credSupID,

[lwa_kna1-name1] as debCompanyName,

[lwa_lfa1-name1] as credCompanyName

What I want is:

[<bseg>-kunnr] as custSupID,

[<bseg>-lifnr] as custSupID (this will give an error because the field is not unique

[lwa_kna1-name1] as companyName,

[lwa_lfa1-name1] as companyName (the same here)

Can I just use sumething like this:

[<bseg>-kunnr] + [<bseg>-lifnr] as custSupID

Will this create a column that holds both ID-numbers?

Re: Error unique fields, combine/merge two fields into one

alexandros17 — Fri, 17 Oct 2014 08:55:12 GMT

Yes to all your questions,

[<bseg>-kunnr] + [<bseg>-lifnr] as custSupID

is correct, just use & instead +

Let me know

Re: Error unique fields, combine/merge two fields into one

Fri, 17 Oct 2014 09:06:24 GMT

And this will place each unique value in a unique field (underneath each other)? Not that it will combine them one behind the other.....

Re: Error unique fields, combine/merge two fields into one

alexandros17 — Fri, 17 Oct 2014 09:11:55 GMT

for each row the contents of the 2 fields will be concatenated in a new field (this happens in each row) ... nothing more

Re: Error unique fields, combine/merge two fields into one

Fri, 17 Oct 2014 09:15:12 GMT

I described the question wrong, I'm sorry. What I want to do is merge/combine two columns into one column. So the new column holds the ID's of the one and the other, but not combined in one field but each ID in a unique field.

Re: Error unique fields, combine/merge two fields into one

stigchel — Fri, 17 Oct 2014 09:16:17 GMT

If you want to have the ID's in one column, so each value in a different row, you can do two seperate loads. If you keep the fields the same they will automatically concatenate into one table.

Load

[<bseg>-kunnr] as custSupID,

[lwa_kna1-name1] as companyName,

From......

Load

[<bseg>-lifnr] as custSupID

[lwa_lfa1-name1] as companyName

from.....

Re: Error unique fields, combine/merge two fields into one

Fri, 17 Oct 2014 09:19:50 GMT

Thanks, that's it!