contat function

[maxronny]

dear all,

i am warried about a problem i can't get a solution. i tried to resolve it with "contact" formula but it doesn't run.

please see the qvw attached.

my goal is to get a result in which, for example, if i select "aaa" i have this issue:

date	amount	supplier	select1	select2
01/01/2020	100	bing	aaa
05/05/2020	160	bing		aaa
30/05/2020	172	bang		aaa
24/06/2020	184	bung		aaa
19/07/2020	196	bong	aaa
13/08/2020	208	beng	aaa
16/12/2020	268	beng		aaa
01/03/2021	304	bung	aaa

hoping to find someone who can help me.

thank U.

[jwjackso · Accepted solution]

You could create a cross-reference table in the load script:

tmpSelect:
load distinct select1 as tmpSelect,
select1,
'-' as select2
Resident Data where select1 <> Null();
Concatenate
LOAD Distinct select2 as tmpSelect,
'-' as select1,
select2
Resident Data where select2 <> Null();