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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703