Join two datatables with no common column

[Selvasathappan (Selva)]

Hello,

Is it possible to join two datatables without common column Ex: I have 3 columns(Name, Age,Job) in dt1 and 1 column (View) in dt2. I would just like to have 4 columns in dt1 now (already existing 3 columns + 1 column from dt2).

I already tried this using merge datatable but the output is not as expected. Please refer the screenshot
smartly.xaml (11.3 KB)

[Zak_Cooper]

It would be a lot easier just to add the items to a new datatable.

Datatable 1 = DT1
Datatable 2 = DT2

in sequence :

Make a new datatable ( NewDT )

[For each row] DT1

get row item “Name” → output = Name

get row item “Age” → output = Age

get row item “job” -. output = Job

add datarow {Name, Age, job} to newDT

[For each row ] DT2

Get row item “view”

add data row {View} to newDT

If that doesn’t make sense then upload your sheets and ill do it for you.

[Selvasathappan (Selva)]

@Zak_Cooper - Can you please help me with the below one?

Sort random - Datatable

Hello Everyone, Is there a way to sort the datatable in a random order? I mean I would like to shuffle the rows of my datatable. Can anyone please help me? I don’t want it follow any order like ascending/descending. I want to induce randomness to the data order. Please note am using version 2017.1.6682. There is no filter datatable activity as such. I usually use select clause for that but how do we do it when we want the data to be in random order?