levi_kim Member

Hi @DavidChurchman , Thanks for your response. Option A is what I'd like to see. I used the Append Rows tile in my Magic ETL but it's not working as expected. A lot of fields that should be populated were empty such as Item Number. For Append Rows tiles, I chose to include all columns. I think I might be missing a key…

Hi @ColemenWilson , Thanks for the quick reply. I will give it a shot but I don't think it's the best option due to the different structure in the datasets. Any other ideas?

Thanks @ColemenWilson ! This should be the solution I was looking for. Now I wait for the alert to trigger.

Thank you @Sean_Tully @MarkSnodgrass @GrantSmith ! Your answers are very insightful and helpful. I will definitely add them to my toolkit. I ended up using Mark's SPLIT_PART function as that was easiest and fit my criteria.

Hi @MichelleH , I wouldn't say new rows are added on a regular basis but I would like to track any changes whether that be new rows or changing quantities or prices which affect total value. I've never tried adding a relative date field to new rows. Do you have any resources that could help? Or any advice on tracking…

Hi @ColemenWilson , Thanks for your response. I tried that beastmode and applied it but it still displays Order Numbers that do not have UN Number. An example below: Null fields can be tricky sometimes with our datasets. We've had to use prompts such as When UN Number = '' and when length('UN Number') < 1 as well because…