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!!
Solved! Go to Solution.
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.
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