Combining 2 different text values from the same field into one combined text value?

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

I am receiving some outputs that all other fields are the same except for one notes field has different notes when all the other info is the same. I want to know how to combine them in the load script or set analysis(preferably load)?

Fieldnames	data output1	dataoutput2
AffiliateCode\|fa_num\|seq#	92922\|4	92922\|4
accum_depr	4,811	4,811
acq_date	11/1/2009	11/1/2009
AffiliateCode\|dept\|fa_class	92922\|8505\|C1770	92922\|8505\|C1770
amount	4,811	4,811
date_to_start_depr	11/1/2009	11/1/2009
fa_desc	IDF SWITCH - CATALYST 3560	IDF SWITCH - CATALYST 3560
fa_stat	A	A
gl_asst_acct	154120	154120
gl_asst_acct_unit1	8505	8505
gl_asst_acct_unit4	1770	1770
gl_exp_acct	637041	637041
gl_res_acct	267120	267120
life	5	5
loc	TORONTO	TORONTO
lst_dep_date	9/1/2014	9/1/2014
model	58024	58024
tag	4	4
Uf_Legacy_Invoice	INV0081713	INV0081713
Uf_Legacy_PO	057726	057726
units_depr	60	60
units_tot	60	60
AffiliateCode\|acct_unit1	92922\|8505	92922\|8505
NoteContent	DOLEMAN TECH, INV0081716, PO #057926, (1) CATALYST 3560 48 10/100 POE+4 SFP IPB IMAGE	OLD NUMBER: G46-10-02-X7	I want to combine these 2 fields into one field how do I do that? It is causing all the other fields to duplicate cause this is the one field that is different
fa_num	4	4
SpecificNoteToken	77971	77971

Thanks,

Josh

Re: Combining 2 different text values from the same field into one combined text value?

Taoufiq_Zarra — Tue, 02 Jun 2020 19:38:58 GMT

@jmcdermott

if I understood correctly

Data: load Fieldnames, if([data output1]=dataoutput2,[data output1],[data output1]&dataoutput2) as [data output1], if([data output1]=dataoutput2,dataoutput2,[data output1]&dataoutput2) as dataoutput2 ; LOAD Fieldnames, [data output1], dataoutput2 FROM [https://community.qlik.com/t5/New-to-QlikView/Combining-2-different-text-values-from-the-same-field-into-one/td-p/1707579] (html, codepage is 1252, embedded labels, table is @1);

topic Re: Combining 2 different text values from the same field into one combined text value? in QlikView

Combining 2 different text values from the same field into one combined text value?

Re: Combining 2 different text values from the same field into one combined text value?