モデル間のインポート

KTKT
KTKT
in Modeling

モデルAにある時間形式のラインアイテムをもとに、モデルBからその日付の各製品の在庫数値をインポートするにはどうするのがいいでしょうか。

image.png

思いついたのは、、
Bで、Aの日付をインポート
Bで、その日付だけの保存済みビューを作成
Aからインポート

Answers

  • seymatas1
    seymatas1

    English:

    Importing Between Models

    How can we import inventory figures for each product from Model B based on a line item in time format that exists in Model A?

    image.png

    What I came up with is:

    1. Import the date from Model A into Model B.
    2. In Model B, create a saved view that filters only for that date.
    3. Import from Model B into Model A.

  • seymatas1
    seymatas1

    Hi @KTKT,

    If these models are so connected, is there a reason why they are separate? Maybe it’s because of size limits or different locations?

    Your solution looks good for now, but it’s worth thinking about how to avoid this situation.

    Here are some points to keep in mind:

    • Avoid real-time imports: Since there are two imports, and data can only be pulled (not pushed) between models, users might need to click two buttons on two different UX pages to run the actions. This can be a bit inconvenient.
    • Automate the process: If possible, use an integration tool like Cloudworks to schedule the imports. This way, the data can flow automatically without users having to do it manually.

    I hope this helps.

    Seyma Tas🌷🙂

  • KTKT
    KTKT

    ありがとうございます。サイズを気にしていました。

    考えてみます！！（全部インポートがよさそうです

Categories