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 CentreBasic SalaryHouse AllowanceCar AllowancePhone Allowance154001-DE5000400500100123001-AB4000300 100123001-ZY3000 500100154001-KU2000300500100 Desired output : Cost CentreBasic SalaryBasic Salary - 123001-ABHouse AllowanceHouse Allowance - 123001-ABCar AllowancePhone AllowancePhone Allowance - 123001-AB154001-DE5000 400 500100 123001-AB 4000 300 100123001-ZY3000 500100 154001-KU2000 300 500100 The main issue is the column sequence is not on any sorting order. Thank you in advance !

Add New Column after Existing Column

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 !

Preparation

Accepted answers

AncientPandaman

you can transpose everything first, then crosstab it again.

open via edit or from designer

Add Columns by cost centre.yxwz

All comments

AncientPandaman

you can transpose everything first, then crosstab it again.

open via edit or from designer

Add Columns by cost centre.yxwz

Yoshiro_Fujimori

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

SelectedRowToNewTable.yxmd

Yoshiro_Fujimori

I converted the Workflow to an APP with Drop Down List. (Just for curiosity😀)

Workflow

Not sure if the Block Until Done tool actually works. It may be necessary to run it twice.

APP Interface

APP Output

SelectedRowToNewTable.yxzp

fikrizahari

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 ?

fikrizahari

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703