Need to join the data

[MKanchwa]

I have two tables - City & Sales Tables. I want to join both with City table repeating itself.

[gawa · Accepted solution]

Hi @MKanchwa 

I understand that you want to append field "city" repeatedly by only reference to the order of record from top row to the bottom row. The below is one way to realize your demand. This workflow can work even with "dynamic" number of cities(in your sample there are 2 cities, but any number is OK) by using combination of count record and formula.

[MKanchwa]

Thank you very much @gawa