Inline Editing and Dataset refresh problem

verytiredgirl
verytiredgirl Member
edited November 6 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:

Comments

  • 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 6

    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

Categories