Error unique fields, combine/merge two fields into one
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?
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.
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.
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.
