Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I was wondering if you can help me to fix the following code:
,pick(wildmatch([Transaction Type],'A', 'B' , 'C')+1,[Transaction Type],'A1', 'B1', 'C1') as [Transaction Type.t] |
;
How to change the code so A & B would be together under A1 ?
You didn't say how you want to group them, so I assume: A & B to A1, C & D to B1, E & F to C1
(and, I removed the unnecessary parts)
,pick(wildmatch([Transaction Type],'A', 'B' , 'C,'D', 'E' , 'F'), 'A1','A1','B1','B1', 'C1','C1') as [Transaction Type.t]
,pick(wildmatch([Transaction Type],'A', 'B' , 'C')+1,[Transaction Type],'A1', 'A1', 'C1') as [Transaction Type.t]
What do you mean when you say A & B would be together under A1? Can you elaborate a little more.
Best,
Sunny
I think it solves the problem.
so if i have A, B, C, D,E, F as transactions and want them to be in 3 groups - A1, A2, A3 - how would you solve that? (AB) (CD)(EF)
how to set up the underlined part?
,pick(wildmatch([Transaction Type],'A', 'B' , 'C,'D', 'E' , 'F')+1,[Transaction Type],'A1', 'B1', 'C1') as [Transaction Type.t]
You didn't say how you want to group them, so I assume: A & B to A1, C & D to B1, E & F to C1
(and, I removed the unnecessary parts)
,pick(wildmatch([Transaction Type],'A', 'B' , 'C,'D', 'E' , 'F'), 'A1','A1','B1','B1', 'C1','C1') as [Transaction Type.t]
Thank you. yes. I edited my response but you guessed correctly and I see the logic and how it flows now and will be able to solve my problem. Thank you.