Alteryx - Data massaging

[ilovecoding]

Hello,

If my Data is like this and i want total of last column (wont mind total of all columns) then what is the way to do it in alteryx?

xyz
EQ
1/31/2023
1291722	A	SDSD	6682	112.68	84986473	112.68	84986473
97916423	B	HJHJ	960	70.12	77474737	70.12	77474737
69723297	C	GJGI	80689	24.28	94976474	24.28	94976474
979329	D	IUGI	5985	172.74	4747747	172.74	4747747
70773070	E	GKG	495	43.51	2874401.13	43.51	2874401.13

[ShankerV]

Hi @ilovecoding 

One way of doing this to get the total of last column.

Many thanks

Shanker V

[binuacs]

@ilovecoding Another option to calculate the column's total was using the transpose and the cross tab tool. The cross tab tool has the options to calculate column total and row total

[ilovecoding]

thanks for response, how did you get Field1 field2 labels? My file doesn't have it and i don't want to write that manually in excel before executing in alteryx

[binuacs]

@ilovecoding you can connect your excel input file in the given workflow. If your excel file doesn't have any column heading, use the below option in the input tool

[ilovecoding]

My source file format is .csv so when i chose select function i see only 2 options rather than several columns. First row contains field names is already checked