Custom Sort on a String type column

[EN6924]

I have a data -

If I use a sort tool on column - "Sub-Client Name", it would give me result in ASC or DESC order.

How should I use custom sorting? The sequence should be like Row 3,5,18,1,14.......etc 

Please guide me.

[EN6924]

Nope, It's not working..

I have data on the test.slsx file on the selected rows (Plus many rows) but in here they're showing blank.

[atcodedog05 · Accepted solution]

Hi @EN6924 

They dont seems to be in your data.

Hope this helps : )

[EN6924]

From our Backup software, a backup for a system failed and later we manually initiated it thus showing completed -

When I'm generating a report in Table tool it's only showing Failed one. But It must be showing the completed one which is latest data, not the failed one.

So, I can apply a Multi-Row formula and but this will work for only single entry -

What will be the resolution when there will be multiple entries? I think the filter should be matched on multiple conditions. I attached main .xlsx file along with the workflow I've created.

I'm not a pro, just learning. Please help. Thanks..🙂

[atcodedog05]

Hi @EN6924 

This is bit confusing how did you get end time. And what is the expected output.

[EN6924]

That is a different entry, just for testing purpose. I copied some previous backup data of the same VM and added Multi-Row and it worked. But not sure it will work for multiple entries or not if there are any....

If you check the main excel file, after filtering you should see like -

Backup for a VM failed earlier and later completed. 

In my excel both entries are present but in Alteryx final output it's only showing the failed one, not the recent one which is completed.

[atcodedog05]

Hi @EN6924 

In your workflow output also i can see it in both completed and failed

Completed

Failed

Hope this helps : )

[EN6924]

Oops that was a mistake from my end.

I need to add a formula to fetch only the completed part, not the failed one.

Thanks for your help. 😊

[atcodedog05]

Happy to help : ) @EN6924 

Cheers and have a nice day!