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

[jmcdermott]

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

[Taoufiq_Zarra · Accepted solution]

@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);