Forum Discussion
how to get the value present in list
Hi,
I have column classification id and calssification as list. The list has only one value . Can you please let me know how to expand the list.
only one value is present in list.
May i know how to get the value that is present in the list.
Thanks.
Hi aswanim
Click on the Double Headed Arrow at the top of the column(s) and then click on Extract Values
Choose No Delimiter when prompted
You'll get errors where the null values were. These can be replaced with whatever you like e.g. right click on the column header and choose Replace Errors
Just click OK on the next prompt
The result being this
regards
Phil
1 Reply
- PhilipTreacy
Super User
Hi aswanim
Click on the Double Headed Arrow at the top of the column(s) and then click on Extract Values
Choose No Delimiter when prompted
You'll get errors where the null values were. These can be replaced with whatever you like e.g. right click on the column header and choose Replace Errors
Just click OK on the next prompt
The result being this
regards
Phil