Combining multiple fields' values into one

jacqueshol — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I hope someone here can help me. I've been searching answers on this blog (and elsewhere ), but have not been able to find a solution for my problem. Although I am pretty sure, someone here will be able to help me with a very simple solution.

I am trying to combine the values of 4 fields (VCCostSubType, FCCostSubType, DepotCostSubType, AdminCostSubType) from 4 different Excel spreadsheets into one field (named GroupSubType). This field (GroupSubType) must show me the contents of these 4 fields as one long list. Basically appended to each other.

For example,

VCCostSubType has values of Fuel, Maintenance, Tyres

and

FCCostSubType has values of Depreciation, Insurance, Claims

and

DepotCostSubType has values of Salaries, Rent, Security

and

AdminCostSubType has values of Telephone, Vehicle_Hire, Audit_Fees

the resultant list box has to be:

GroupSubType
Fuel Maintenance Tyres Depreciation Insurance Claims Salaries Rent Security Telephone Vehicle_Hire Audit_Fees

GroupSubType

Fuel

Maintenance

Tyres

Depreciation

Insurance

Claims

Salaries

Rent

Security

Telephone

Vehicle_Hire

Audit_Fees

I need to be clear. I don't need concatenation, e.g. = field1 & field 2 resulting in FuelDepreciation. It needs to be presented as one long list made up of separate values. I also can't do a manual inline load, as the values changes on a month to month basis and can be quite extensive. Each of these 4 fields can have up to 60-80 values each.

Thanking you all in anticipation.

Take care,

Jacques

Re: Combining multiple fields' values into one

kaushiknsolanki — Tue, 26 Jul 2016 08:56:43 GMT

Hi,

You can do like this.

Load VCCostSubType as GroupSubType from XYZ;

Concatenate

Load FCCostSubType as GroupSubType from XYZ1;

Concatenate

Load DepotCostSubType as GroupSubType from XYZ2;

Concatenate

Load AdminCostSubType as GroupSubType from XYZ3;

Regards,

Kaushik Solanki

Re: Combining multiple fields' values into one

jacqueshol — Tue, 26 Jul 2016 09:07:34 GMT

Thank you so much Kaushik! Wow, that was quick! And the solution works perfectly

Thanks again.

Cheers,

Jacques

topic Re: Combining multiple fields' values into one in QlikView

Combining multiple fields' values into one

Re: Combining multiple fields' values into one

Re: Combining multiple fields' values into one