Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below List of Countries..
Data:
Load * Inline
[
Country
(Not Specified)
USA
India
UK
Germany
France
Canada
];
I want to create a List Box which will sort all Countries according to text format but (Not Specified) should come at last.
How to achieve this?
On the Sort pane, check both "Text" and "Expression". Use this for the sort expression:
match(Country,'(Not Specified)')
-Rob
Put all values in the correct order and in the list box sort by "load order".
I can't do that... It is coming from SQL database and I have more than 200 countries.
There is nothing there which can help me in my problem.
On the Sort pane, check both "Text" and "Expression". Use this for the sort expression:
match(Country,'(Not Specified)')
-Rob
What you could do is still create the INLINE table with all the values in the order you like, next load the actual data from the database, next drop that INLINE table, and still end up sorting by load order .
How can I create an Inline table if I don't know exactly how many and which countries are going to appear from database. Your solution is not the one which could help me. But yes, thanks for your reply !
Hi Rob Wunderlich,
This is what exactly I want. It's working perfectly.
Could you please let me know how it works?
Here are 3 ways to create an inline table that does what you need. The actual countries in your dataset is not relevant for every solution.