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.
Hi @EN6924
They dont seems to be in your data.
Hope this helps : )
You need to have a lookup table with a custom sort order. Use lookup to map order and sort it.
Workflow:
Hi @EN6924 ,
What's the logic behind the sorting you are trying to apply? If it's on a field that only contains characters, probably the easiest but painful way to sort it is with a lookup table.
You can copy all client names and then manually assign an ID to each one of them, in the order you want those to appear in your sorting, Then you can join back to the main data stream and use that new field to sort your data.
@EN6924 Agree with @atcodedog05 , if we need a custom sort, we need a definition table as one of the inputs.
Hello All,
We have a Backup software from where we use to fetch backup data on daily basis and create a report in the below format -
From my experiment, The data I'm getting in ASC order listed below -
Need to arrange the row sequence in proper format (by default as suggested by Customer)
Note: Monthly backups will not happen on daily basis, so in the first format some fields are blank.
@atcodedog05 - Tried to create a lookup table with a custom sort order. Use lookup to map order and sort it. But this is not working.
Kindly suggest.
Please provide the test.xlsx file or else we won't be able to run the workflow and check.
It would be something like below.
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..🙂
This is bit confusing how did you get end time. And what is the expected output.
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.
