Linking two schema exports

#1

Hopefully this ask makes sense. Every time I attempt to think through it brain cells die.
I have a large project with many different schemas. The schemas are linked via a ‘Lookup key’ schema.

My main data set schema “Account” produces a fake company name ‘Name’. In the second data set schema ‘loans’ I’d like it to reference and pull in the account name ‘Name’ created in the Account schema.

Is there a way to accomplish this?

#2

Yes, the process is covered here: https://www.youtube.com/watch?v=XATDlwG1azU&list=PLKMZcxOsC3u0Y-4CHg5SDpVjTcrvGttTt&index=1

#3

Thanks. What is the record limit on the dataset upload? Appears to be erroring out at 100k

#4

The row limits are listed here:

#5

These limits apply to uploading datasets to link two schemas?

#6

Uploads have a hard limit of 30MB per file, regardless of plan. If you only need a primary key from a dataset, I suggest pulling that column into a separate file. You’ll be able to upload many more rows due to the reduced file size.