Joining the data from two inputs

[Pravallika20]

Hi everyone,

I am having two excels with the data sets as:

field1	field2
a	e
b	f
c	g
d	h
i	m
j	n
k	o
l	p
q	u
r	v
s	w
t	x

field3	field4
1	5
2	6
3	7
4	8

my final output should be :

field1	field2	field3	field4
a	e	1	5
b	f	2	6
c	g	3	7
d	h	4	8
i	m	1	5
j	n	2	6
k	o	3	7
l	p	4	8
q	u	1	5
r	v	2	6
s	w	3	7
t	x	4	8

 Can anyone please help me on this? Thanks in advance!!

[mceleavey]

Hi @Pravallika20 ,

this is an interesting one as it calls for repeating by how many records there are in input 2.

To do this I determined the number of records by assigning a record ID, then generated a multi row formula to create a repeating sequence of these numbers in input 1:

I then joined them together on these fields:

Hope this helps,

M.

[OllieClarke · Accepted solution]

Hey @Pravallika20 

How's this?

[Pravallika20]

Hi @mceleavey ,

Can u please attach the workflow

[Pravallika20]

Hi @OllieClarke ,

This is perfect thank you so much

[mceleavey]

@Pravallika20 

apologies!

M.

[suby]

Hi 

Could you please explain the expression below.

if [Row-1:RecordID]=[Row-1:Max_RecordID] then 1 else [Row-1:RecordID]+1 endif

Thanks