Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Delete specific cell content based on content of another cell

flowrider
5 - Atom

Hi all,

 

I have an issue where due to the way two different data sources are structured I end up with something as the example below:

 

SKU NumberSales QTYDatePromotion TextPromotion Qty
12345620Jan 2019Promo 1 January2
12345620Jan 2019Promo 2 for 1 Jan8
12345620Jan 2019Promo 2 January1
12345620Jan 2019Promo 3 for 40
12345625Feb 2019Promo 2 for 1 Feb1
12345625Feb 2019Promo 2 Feb6
12345625Feb 2019Promo 2 for 42

 

My issue is now, that one SKU can be in one month on multiple Promotions (Promotion Text needs to be distinguishable, and in separate rows as analysis afterwards will be "How much products do we sell through Promo vs. Non-Promo") and the Sales QTY for SKU #123456 is currently 4 x 20, although it actually is only sold in total 20 times in January. As I use this data to build Tableau Dashboards I need all Sales QTY fields except for one to be empty, so when looking at Sales QTY January vs. Promotion QTY Total it would be 20 vs. 11, but when looking at Sales QTY vs. 'Promo 2 for 1 Jan' would be 20 vs. 8. 

 

I hope this makes any sense to someone of you...

 

Thanks a million!!

2 REPLIES 2
deviseetharaman
11 - Bolide

Hi @flowrider 

 

Is this what you are looking for:

 

delete.png

flowrider
5 - Atom

That's perfect, it definitely did the job! Thanks a lot @deviseetharaman !

Labels