Inline Editing and Dataset refresh problem

verytiredgirl
verytiredgirl Member
edited November 2024 in Magic ETL

Context: I have a Dataflow that has 2 Input Dataset (Product Sales 1, Product Sales 2) and an Output Dataset (to find rows that are in Product Sales 1 but not in Product Sales 2). And this Dataflow triggers monthly when Product Sales 1 and 2 get appended.

I want to add a commentary column in the Output Dataset using Inline Editing, but the problem with Inline Editing is that once my DataFlow refreshes, the commentary column will return blank.

Tagged:

Best Answer

  • Craig_Lynch
    Craig_Lynch Contributor
    Answer ✓

    essentially it should work like a recursive dataset. By using the output dataset as an input, you bring the data from the last update into the ETL before it's changed. So you take the commentary and join it to the data instead of your webform. Use a Select Columns or Alter Columns before the join to only include the columns you need to make the join and the commentary.

    image.png

Answers

  • Craig_Lynch
    Craig_Lynch Contributor

    Have you tried including the output dataset as an input dataset, then joining the updated column to the appended data?

  • verytiredgirl
    verytiredgirl Member
    edited November 2024

    I have not tried it yet and I'm also new to Inline Editing so I'm not sure how to join the updated column to the appended dataset, could you explain it a little bit more?

    But I do have a webform that basically has the same as the Output Dataset, but with the commentary columns. Then I left joined the Output Dataset (left) & the webform in the same dataflow above.

    image.png


    However with this method, I'll have to manually update all new missing orders rows in the webform & add the commentary in the comment column as well

  • Craig_Lynch
    Craig_Lynch Contributor
    Answer ✓

    essentially it should work like a recursive dataset. By using the output dataset as an input, you bring the data from the last update into the ETL before it's changed. So you take the commentary and join it to the data instead of your webform. Use a Select Columns or Alter Columns before the join to only include the columns you need to make the join and the commentary.

    image.png

Categories