How to create formula from 1 column become 2 columns

Lydieatantra

Hi Alteryx Team,

Kindly need your help to create the workflow as attached below, since im newby in Alteryx.

Current

GL Amount

1000

2500

-2000

-1500

Expected

GL Amount	Incoming	Outgoing
1000	1000
2500	2500
-2000		-2000
-1500		-1500

Thank you.

Lydiea

Common Use Cases

Accepted answers

grazitti_sapna

Hi @Lydieatantra , I have created two approaches to get the desired output please refer to the screenshot and workflow attached.

Thanks

formulaforcolumns.yxmd

Lydieatantra

Hi @grazitti_sapna ,

May i raise the other question regarding my workflow ?

Actualy i need to summarize the data has been created before. I just want to show the decription for "NOT RECONCILE" items.

Please see my data below :

Current

Description	Status	Name	Value	Source
payment 1	RECONCILE	Incoming	1000	GL
payment 2	NOT RECONCILE	Outgoing	-1500	GL
payment 5	NOT RECONCILE	Outgoing	-1000	GL
payment 3	NOT RECONCILE	Incoming	2000	GL
payment 4	RECONCILE	Outgoing	-3000	GL

Expected

Name	Status	Description	Value
Incoming	RECONCILE		1000
Incoming	NOT RECONCILE	payment 3	2000
Outgoing	RECONCILE		-3000
Outgoing	NOT RECONCILE	payment 2	-1500
Outgoing	NOT RECONCILE	payment 5	-1000
GL Movement			-2500

Hoping i can get the solution 😉

Thank you.

Lydiea

rahul_Kumar_koshika

Hi @Lydieatantra ,

I have created workflow which just show the description for "NOT RECONCILE" items (as per your requirement.

Please find the below alteryx workflow.

Thanks

Solution.yxmd

grazitti_sapna

Hi @Lydieatantra , I have tried to work on it please refer to the workflow and attachment if this looks fine to you?

Thanks.

formulaforcolumns-newrequirement.yxmd

All comments

grazitti_sapna

Hi @Lydieatantra , I have created two approaches to get the desired output please refer to the screenshot and workflow attached.

Thanks

formulaforcolumns.yxmd

Lydieatantra

Hi @grazitti_sapna , thank you so much for your help 😉

Regards,

Lydiea

Lydieatantra

Hi @grazitti_sapna ,

May i raise the other question regarding my workflow ?

Actualy i need to summarize the data has been created before. I just want to show the decription for "NOT RECONCILE" items.

Please see my data below :

Current

Description	Status	Name	Value	Source
payment 1	RECONCILE	Incoming	1000	GL
payment 2	NOT RECONCILE	Outgoing	-1500	GL
payment 5	NOT RECONCILE	Outgoing	-1000	GL
payment 3	NOT RECONCILE	Incoming	2000	GL
payment 4	RECONCILE	Outgoing	-3000	GL

Expected

Name	Status	Description	Value
Incoming	RECONCILE		1000
Incoming	NOT RECONCILE	payment 3	2000
Outgoing	RECONCILE		-3000
Outgoing	NOT RECONCILE	payment 2	-1500
Outgoing	NOT RECONCILE	payment 5	-1000
GL Movement			-2500

Hoping i can get the solution 😉

Thank you.

Lydiea

grazitti_sapna

Hi @Lydieatantra , I have tried to work on it please refer to the workflow and attachment if this looks fine to you?

Thanks.

formulaforcolumns-newrequirement.yxmd

Lydieatantra

Hi @grazitti_sapna ,

Thank you for your help.

And how about if i want to add a new row to create the different from 2 rows.

The additional row is for [Different] = [Bank Movement] - [GL Movement]

Current

Source	Name	Status	Value
Bank	Incoming		2500
Bank	Outgoing		500
Bank	Bank Movement		2000
GL	Incoming	RECONCILE	5000
GL	Outgoing	RECONCILE	1500
GL	Outgoing	NOT RECONCILE	500
GL	Outgoing	NOT RECONCILE	1000
GL	GL Movement		2000

Expected

Source	Name	Status	Value
Bank	Incoming		2500
Bank	Outgoing		500
Bank	Bank Movement		2000
GL	Incoming	RECONCILE	5000
GL	Outgoing	RECONCILE	1500
GL	Outgoing	NOT RECONCILE	500
GL	Outgoing	NOT RECONCILE	1000
GL	GL Movement		2000
Different	Movement		-

Thank you.

Lydiea

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703