Hi, my R code and output in Rstudio looks like below. How do I do the same in alteryx? data.tb ## Output --> namedatejohn smith2022-07-21 file.df namedatemessagejohn smith2022-07-21hello world Issue: when I try to do the same in alteryx, only the value is getting filled, but not the column names. I am getting below output in alteryx ## Output --> col_acol_bmessagejohn smith2022-07-21hello world

how to update both column name and column value at the same time using R tool

Hi, my R code and output in Rstudio looks like below. How do I do the same in alteryx?

data.tb

## Output -->

name	date
john smith	2022-07-21

file.df <- data.frame(

col_a = data.tb[1,1]

col_b = data.tb[1,2]

message = "hello world"

)

file.df

## Output -->

name	date	message
john smith	2022-07-21	hello world

Issue: when I try to do the same in alteryx, only the value is getting filled, but not the column names. I am getting below output in alteryx

## Output -->

col_a	col_b	message
john smith	2022-07-21	hello world

R Tool

There are several ways to do this. Here's one:

df <- read.Alteryx("#1", mode="data.frame")
df["message"] = "hello world"
write.Alteryx(df, 1)

See attached...

Hi, thank you for your solution. But I am trying to rename the first two columns as well.

so from col_a and col_b to name and date. I know i can use select tool to do it afterwards. But I am asking if it's possible to do it using R tool?

This is pretty simple in Alteryx with the Join tool but for R I'd suggest looking into merge.

ok thank you i will look into it

Hello @nkazi01, try this if it helps?

Thanks!