Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Is it possible to take two text fields and map them together
e.g. Item + product = itemproduct so it produces a unique field to map against in another table (which i've created separately)
these are in two separate tables
audicar
auditruck
audilorry
bmwcar
bmwtruck
bmwlorry
fordcar
fordtruck
fordlorry
so every time audi and car appear it is audicar
Thank you for your time
try:
item&product as itemproduct
Thanks for your reply. Where would I put this syntax? Will this work for two different tables?
Table 1 has the item in and table 2 has the product in.
I guess not. It's working only these field in 1 table. So i think you should join these 2 tables.
Give us some example or something.
one table has departments and amounts, and the other has industry codes in and i've created this table below. what I need is department and industry codes so I can map it to other tables as a unique identifier. at the moment there is no unique id that says FRT and CAR= FRT commercial
The idea is to select FRT commercial and just get a total of all the FRT commercial. problem is that when I select FRT commercial now I get the total of FRT and any industry that has aviation car cater charity in it (i.e. a total of everything)
ID | Department | Industry Code | Industry Description | New Department |
FRTAVIATION | FRT | AVIATION | Aviation - NOT OPERATORS | FRT Commercial |
FRTCAR | FRT | CAR | Car / Motor-related Co s | FRT Commercial |
FRTCATER | FRT | CATER | Catering | FRT Commercial |
FRTCHARITY | FRT | CHARITY | Charities and foundations | FRT Government |
FRTTCAVIATION | FRTTC | AVIATION | Aviation - NOT OPERATORS | FRT Time Critical |
FRTTCCAR | FRTTC | CAR | Car / Motor-related Co s | FRT Time Critical |
FRTTCCATER | FRTTC | CATER | Catering | FRT Time Critical |
FRTTCCHARITY | FRTTC | CHARITY | Charities and foundations | FRT Time Critical |
CADAVIATION | CAD | AVIATION | Aviation - NOT OPERATORS | CJ Other |
CADCAR | CAD | CAR | Car / Motor-related Co s | CJ Other |
CADCATER | CAD | CATER | Catering | CJ Other |
CADCHARITY | CAD | CHARITY | Charities and foundations | CJ Other |
EADAVIATION | EAD | AVIATION | Aviation - NOT OPERATORS | PJ ADHOC |
EADCAR | EAD | CAR | Car / Motor-related Co s | PJ ADHOC |
EADCATER | EAD | CATER | Catering | PJ ADHOC |
EADCHARITY | EAD | CHARITY | Charities and foundations | PJ ADHOC |