How to cross join with AETL?

Say I have table one with few list of task for each new candidates

Get paperwork done
Give email id
Introduce to team
Clear security
Introduce to client

Another table with candidates names

Prashant
Tim
Jones

I had like to do a cross join like below

Prashant,Get paperwork done
Prashant,Give email id
Prashant,Introduce to team
Prashant,Clear security
Prashant,Introduce to client
Tim,Get paperwork done
Tim,Give email id
Tim,Introduce to team
Tim,Clear security
Tim,Introduce to client
Jones,Get paperwork done
Jones,Give email id
Jones,Introduce to team
Jones,Clear security
Jones,Introduce to client

See how it's done in another product
 

 

Not sure that it is possible right now.

We might need to add a new object.

Having thought about it I do not think there is a need to add a new transformation object.

It is rather very easy to do using exiting Joiner.

All you need to do is to assign the same ID to all records.

Please see an example attached. We have also included the cross join example to the latest release.

 

admin wrote:

Please see an example attached. We have also included the cross join example to the latest release.

 

Clever use of inner join !

It works great !! I tried increasing couple of columns more in both the csv files , and it still works .