community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

generate null rows

Asteroid

I have a table as follows.For each column App,Product and Category.I need to get rows for each severity i.e High,medium and low ,If severity is present then no change if severity low/medium is not present then generate a row with 0 or null values.How to accomplish this any suggestions is helpful.

 

dateStartEndSeverityopenclosereopenLocationAppproductcategory
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High010CFGAIX 7IBMOS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High2160CFGAIX 7IBMDB
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High170CFGAIX 7IBMDB
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High010CFGAIX 7Third PartyApp/OS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High150CFGAIX 7Third PartyApp/OS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High100CFGAIX 7Third PartyApp/OS
Alteryx Certified Partner

Hi @dexter90 ,

 

Can you provide an example of your output table? Only to check for the right solution for you.

 

Best,

Fernando V.

Asteroid

output :

dateStartEndSeverityopenclosereopenLocationAppproductcategory
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High010CFGAIX 7IBMOS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High2160CFGAIX 7IBMDB
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High170CFGAIX 7IBMDB
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High010CFGAIX 7Third PartyApp/OS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High150CFGAIX 7Third PartyApp/OS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59High100CFGAIX 7Third PartyApp/OS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Medium000CFGAIX 7IBMOS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Medium000CFGAIX 7IBMDB
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Medium000CFGAIX 7IBMDB
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Medium000CFGAIX 7Third PartyApp/OS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Medium000CFGAIX 7Third PartyApp/OS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Medium000CFGAIX 7Third PartyApp/OS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Low000CFGAIX 7IBMOS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Low000CFGAIX 7IBMDB
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Low000CFGAIX 7IBMDB
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Low000CFGAIX 7Third PartyApp/OS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Low000CFGAIX 7Third PartyApp/OS
11/20/2019 23:0211/1/2019 0:0011/30/2019 23:59Low000CFGAIX 7Third PartyApp/OS
Labels