Inline Editing and Dataset refresh problem

verytiredgirl

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.

Craig_Lynch

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.

Craig_Lynch

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

verytiredgirl

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.

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

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.