Can any one help on this I need a function or a logic which gives expected outpu

RAAS INFOTEK LLC over 8 years ago

Can any one help on this I need a function or a logic which gives expected output from two arrays.
each variable from array1 should map with all variables in array2.
{a,b} {c,d,e} output (a,c)(a,d)(a,e)(b,c)(b,d)(b,e)
{a} {b,c,d} output (a,b)(a,c)(a,d)

Thanks

Discussion posts and replies are publicly visible

Parents

0 RAAS INFOTEK LLC over 8 years ago

Sorry @stefanh791 I am getting same o/p as above I will explain a bit clearly.
Exp(empId(num(int))array,courseId(num(int))array)
apply(
'Test_table'(
empId:_,
courseId: _,
createdOn: now(),
createdBy: loggedInUser()
),
{ri!empId,ri!couseId}---each employe should register with all courses and i have Insert them into db.
)
for ex: empId{1,2} courseId{22,33,44}
Expected output:
[empId=1, courseId=22,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk];
[empId=1, courseId=33,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk];
[empId=1, courseId=44,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk];
[empId=2, courseId=22,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk];
[empId=2, courseId=33,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk];
[empId=2, courseId=44,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 RAAS INFOTEK LLC over 8 years ago

Sorry @stefanh791 I am getting same o/p as above I will explain a bit clearly.
Exp(empId(num(int))array,courseId(num(int))array)
apply(
'Test_table'(
empId:_,
courseId: _,
createdOn: now(),
createdBy: loggedInUser()
),
{ri!empId,ri!couseId}---each employe should register with all courses and i have Insert them into db.
)
for ex: empId{1,2} courseId{22,33,44}
Expected output:
[empId=1, courseId=22,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk];
[empId=1, courseId=33,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk];
[empId=1, courseId=44,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk];
[empId=2, courseId=22,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk];
[empId=2, courseId=33,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk];
[empId=2, courseId=44,createdOn=5/6/2016 3:35 PM EDT, createdBy=ramuk]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data