Add New Column after Existing Column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Greetings !
I would like to create another columns after existing table, based on value written by user.
I understand that the value can be input via 'Text Box' tools, but I have difficulties to sort back the column sequence.
For example, user input 'cost centre' : 123001-AB
If its match with any 'cost centre', it require to create another column on the right side ( only require for non-zero column ).
Input data :
Cost Centre | Basic Salary | House Allowance | Car Allowance | Phone Allowance |
154001-DE | 5000 | 400 | 500 | 100 |
123001-AB | 4000 | 300 | 100 | |
123001-ZY | 3000 | 500 | 100 | |
154001-KU | 2000 | 300 | 500 | 100 |
Desired output :
Cost Centre | Basic Salary | Basic Salary - 123001-AB | House Allowance | House Allowance - 123001-AB | Car Allowance | Phone Allowance | Phone Allowance - 123001-AB |
154001-DE | 5000 | 400 | 500 | 100 | |||
123001-AB | 4000 | 300 | 100 | ||||
123001-ZY | 3000 | 500 | 100 | ||||
154001-KU | 2000 | 300 | 500 | 100 |
The main issue is the column sequence is not on any sorting order.
Thank you in advance !
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @fikrizahari ,
It may not be exactly match with your requirement,
but I would do this way as I prefer keeping the original table format.
Please take this as another approach.
Workflow
Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @PangHC
It worked !
I would like to ask :
1) May i know the reason to change data type ? Is that mandatory ?
2) How do you set the cost centre '123001-AB' on the text box tool ?
and how do i change if i want to test with other cost centre ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
1. type is not necessary, but the size yes.
bug for text input, always keep lowest data type.
before only 15, not enough character for adding cost center behind.
2. it an application format, good to implement as users need not have knowledge to alteryx.
when you double click the file in folder, it will pop out this. (provided alteryx designer)
so users only need to fill-in certain criteria and get their required result (via the output file)
*user cant see the result window, so you need to have output tool to let user check result via the excel file (for example).
you can learn it in interactive lessons
Help Doc link: Analytic Apps | Alteryx Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @PangHC
Thank you for your answers and suggestions.
It is the solution that I am looking for, appreciate it !
Hi @Yoshiro_Fujimori
Thank you for your answer, its really helpful and gave me another idea.
I also has combined the drop down list that you mentioned, into my workflow. 😆
However, I would like to combine the table instead of make it separate.
It is fine, since Pang Hee Choy already gave me the solution above.
