Jump to content


Photo

how to add a column in data wizard


  • Please log in to reply
5 replies to this topic

#1 shannen

shannen

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 04 September 2019 - 02:52 PM

How to add a new column using transformation in data wizard?


Edited by shannen, 04 September 2019 - 02:54 PM.


#2 Ana Henry

Ana Henry

    Advanced Member

  • Members
  • PipPipPip
  • 220 posts

Posted 04 September 2019 - 03:04 PM

How to add a new column using transformation in data wizard?

Hello,

Within the Data Wizard you can add a Transformation then select Transformation type>Custom  you will see that you need to enter a New Column Name.  In the formula, you can indicate what that column should be or leave blank for a blank column.

 

Hope this helps,

Ana



#3 Simon Davis

Simon Davis

    Advanced Member

  • Administrators
  • 1,112 posts

Posted 04 September 2019 - 03:06 PM

Hi Shannen, First you would choose action of transformation in the drop down.

 

And then click Add

 

you then need to fill out the fields marked with red asterisks,

 in the example below time_hours is the new column created

 

Have a go with that and if you get stuck please reply with your project.

 

also try the new online help to find some workd examples,

 

https://onlinehelp.c...zardexample.htm

 

there are many more on the forum too, e.g.

 

https://support.cert...izard#entry5421

 

 Simon.

Attached Thumbnails

  • choose_action_transforrmation.jpg
  • time_hours.jpg


#4 shannen

shannen

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 05 September 2019 - 12:29 AM

 

 

 

Thanks so much for helping, but the transformation function seems like only transform an existing column to a new column, but can not add a new column, right?


Edited by Simon Davis, 05 September 2019 - 04:55 AM.
no need to quote full posts


#5 Simon Davis

Simon Davis

    Advanced Member

  • Administrators
  • 1,112 posts

Posted 05 September 2019 - 04:53 AM

Shannen, it's still unclear to me what it is you want to do, what is it you want to do with this new column? did you read the help file I pointed you to? that showed a transformation from a baseline.

 

I attach an example in v8.1, (althoguh v8.2 was released in July so I recommend being on the latest version if possible), where no reference is made to a prior column and creates 2 new columns - is that what you are asking?

 

The attached project shows another option, the custom transformation, which will allow you to create an empty column, one containing any text or indeed anything you can write a formula for, (see function list to the right).

 

  Simon.

Attached Thumbnails

  • 2new_columns.jpg

Attached Files


Edited by Simon Davis, 05 September 2019 - 04:56 AM.

  • shannen likes this

#6 shannen

shannen

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 05 September 2019 - 12:59 PM

Shannen, it's still unclear to me what it is you want to do, what is it you want to do with this new column? did you read the help file I pointed you to? that showed a transformation from a baseline.

 

I attach an example in v8.1, (althoguh v8.2 was released in July so I recommend being on the latest version if possible), where no reference is made to a prior column and creates 2 new columns - is that what you are asking?

 

The attached project shows another option, the custom transformation, which will allow you to create an empty column, one containing any text or indeed anything you can write a formula for, (see function list to the right).

 

  Simon.

Thanks so much Simon. This helps!

 

I was trying to add a new column named formulation in dataset 1 using if(ID>0, "oral", "iv"), and did the same thing with dataset 2 using if(ID>0, "iv", "oral"). But after that, when I append two datasets together, the contents in the formulation column all disappeared. I guess it's because the ID in dataset 1 and 2 are the same, so the program don't know which function to use? That's where I got confused. But what you are showing here is a better way to do it. Thanks  :)






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users