Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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();
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();