Append and changing entry of stats

[xeokydo]

It looks that i am on the right track, thanks to forum and your help. Thank you very much.

I am wondering about two things at the moment.

When i use the Stat transformation, it will write Sum in the first column. Could i have this entry in a different column and could i have my local translation instead of Sum?

Secondly:
I have a lookup transformation to create a new column with a specific entry, therefore the Data looks like this:

I’d like to have a XLSX as a report, which appends the first entry to table Consulting, the second one to Table Support and the third one to table Programming

Any chance to achieve that?

[Admin]

@xeokydo

Could i have this entry in a different column

It only really makes sense for Stats to place the sum in the same column.

You can use transforms to manipulate it into a different column.

@xeokydo

could i have my local translation instead of Sum?

You can use Replace to change it from ‘Sum’.

@xeokydo

I’d like to have a XLSX as a report, which appends the first entry to table Consulting, the second one to Table Support and the third one to table Programming

Any chance to achieve that?

Yes, use the multiple files output feature.

How do I? > Split a dataset into multiple files

multi-sheet.transform (2.2 KB)