# How can I change the Aldex .clr result in R to the table file which can be downloaded ?

**URL:** https://forum.qiime2.org/t/how-can-i-change-the-aldex-clr-result-in-r-to-the-table-file-which-can-be-downloaded/25781
**Category:** Other Bioinformatics Tools
**Tags:** normalization, r
**Created:** [March 14, 2023, 9:02am UTC](https://forum.qiime2.org/t/how-can-i-change-the-aldex-clr-result-in-r-to-the-table-file-which-can-be-downloaded/25781 "2023-03-14T09:02:01Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![SingeunOh](https://forum.qiime2.org/user_avatar/forum.qiime2.org/singeunoh/32/15223_2.png) [@SingeunOh](https://forum.qiime2.org/u/SingeunOh)
#### Post date: [March 14, 2023, 9:02am UTC](https://forum.qiime2.org/t/how-can-i-change-the-aldex-clr-result-in-r-to-the-table-file-which-can-be-downloaded/25781/1 "2023-03-14T09:02:01Z")

</div>

Hello,

I've tried to transform my ASV read count files to the CLR form by using R Aldex2 packages.

I've got some results from it, but there is a problem. As below, the results are just shown line by line and there is no downloading button in the interface.

 ![clr results](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/c/c65fb91e2bedbfb7f3118872ee7dfda2bb690af1.png)

How can I change this result to the table form that could be downloaded ?

Thank you for your help in advance.

---

<div class="post-metadata">

### Author: ![Micro\_Biologist](https://forum.qiime2.org/user_avatar/forum.qiime2.org/micro_biologist/32/4190_2.png) [@Micro\_Biologist](https://forum.qiime2.org/u/Micro_Biologist)
#### Post date: [March 14, 2023, 9:08am UTC](https://forum.qiime2.org/t/how-can-i-change-the-aldex-clr-result-in-r-to-the-table-file-which-can-be-downloaded/25781/2 "2023-03-14T09:08:27Z")

</div>

I'm not sure what format the output is, but this is a catchall method:

```auto
sink("output.txt")

#run command that gives the output
run

#close the file
sink()

```

If the output is a dataframe googleing "dataframe to csv in R" should get something useable.

---

<div class="post-metadata">

### Author: ![SingeunOh](https://forum.qiime2.org/user_avatar/forum.qiime2.org/singeunoh/32/15223_2.png) [@SingeunOh](https://forum.qiime2.org/u/SingeunOh)
#### Post date: [April 5, 2023, 12:11am UTC](https://forum.qiime2.org/t/how-can-i-change-the-aldex-clr-result-in-r-to-the-table-file-which-can-be-downloaded/25781/3 "2023-04-05T00:11:14Z")

</div>

Thank you dear. I've learned a new thing and solved the problem well.
