Combine values from two different Fields

qlikwiz123 — Sat, 16 Nov 2024 00:10:29 GMT

I have two Fields- BRANCH and LOCAL in two different tables

TableA:

BRANCH

ACCOUNTS

LEGAL

SERVICES

TRAVEL

SUPPLY

TableB:

LOCAL

SALES

CORPORATE

MARKETING

EVENTS

MAINTENANCE

MEDICAL

PUBLICITY

I need to create a new combined Field with all the combinations of the values from the two fields

Combined Field:

ACCOUNTS_SALES

ACCOUNTS_CORPORATE

ACCOUNTS_MARKETING

ACCOUNTS_EVENTS

ACCOUNTS_MAINTENANCE

ACCOUNTS_MEDICAL

ACCOUNTS_PUBLICITY

SUPPLY_SALES

SUPPLY_CORPORATE

SUPPLY_MARKETING

SUPPLY_EVENTS

SUPPLY_SUPPLY

SUPPLY_MEDICAL

SUPPLY_PUBLICITY

Whenever a user selects ACCOUNTS_SALES in the Combined Field, it should select 'ACCOUNTS' in BRANCH and 'SALES' in LOCAL. Similarly, selecting SUPPLY_PUBLICITY should select 'SUPPLY' in BRANCH and 'PUBLICITY' in LOCAL fields.

Re: Combine values from two different Fields

Saravanan_Desingh — Mon, 10 Aug 2020 01:11:17 GMT

Try this.

BRANCH: LOAD * INLINE [ BRANCH ACCOUNTS HR LEGAL IT SERVICES TRAVEL SUPPLY ]; Outer Join(BRANCH) LOCAL: LOAD * INLINE [ LOCAL SALES CORPORATE MARKETING EVENTS MAINTENANCE MEDICAL PUBLICITY ]; Combined: NoConcatenate LOAD BRANCH, LOCAL, BRANCH&'_'&LOCAL As [Combined Field] Resident BRANCH; Drop Table BRANCH;

topic Re: Combine values from two different Fields in QlikView

Combine values from two different Fields

Re: Combine values from two different Fields