Excel Pivot Logic
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
- Mark as New
- Subscribe to RSS Feed
- Permalink
Hi Experts,
I'm confused in an logic. Please help me !
Expected output is below-
Number | Type | Status | Alteryx Status |
404 | H/D | Close | H/D Open |
404 | Not Started | H/D Open | |
404 | S/D | Close | H/D Open |
404 | Close | H/D Open | |
303 | H/D | Close | H/D & S/D Open |
303 | Not Started | H/D & S/D Open | |
303 | S/D | Close | H/D & S/D Open |
303 | Not Started | H/D & S/D Open | |
305 | H/D | Close | Close |
305 | Close | Close | |
305 | S/D | Close | Close |
305 | Close | Close | |
402 | H/D | Close | Open |
402 | Close | Open | |
402 | (Blank) | Open | |
402 | S/D | Close | Open |
402 | Close | Open |
Can't have multiple comments. for the same documents.
Thanks in advance
- Mark as New
- Subscribe to RSS Feed
- Permalink
Hi @AS
Can you provide some sample input and expected output it will help us get a better understanding of the usecase.
- Mark as New
- Subscribe to RSS Feed
- Permalink
The input table is contains Number, Type and Status. On the bases of Status I'm writing Alteryx Status.
Number | Type | Status | Alteryx Status |
404 | H/D | Close | H/D Open |
404 | H/D | Not Started | H/D Open |
404 | S/D | Close | H/D Open |
404 | S/D | Close | H/D Open |
303 | H/D | Close | H/D & S/D Open |
303 | H/D | Not Started | H/D & S/D Open |
303 | S/D | Close | H/D & S/D Open |
303 | S/D | Not Started | H/D & S/D Open |
305 | H/D | Close | Close |
305 | H/D | Close | Close |
305 | S/D | Close | Close |
305 | S/D | Close | Close |
402 | H/D | Close | Open |
402 | H/D | Close | Open |
402 | H/D | (Blank) | Open |
402 | S/D | Close | Open |
402 | S/D | Close | Open |
- Mark as New
- Subscribe to RSS Feed
- Permalink
getting some unusual outputs while using contains() please help. sharing screenshots. I wrote if status !contains("Close >>",Target) then output must be open but not getting correct answer.
- Mark as New
- Subscribe to RSS Feed
- Permalink
Hi @AS
Can you try only this also dont add ,1 at the end.
!contains("Close",Target)
Hope this helps : )