How to select only distinct rows from the lookup table? I am selecting student details but I have duplicates in the lookup, so how to select only distinct rows from lookup?
You can use dedup command to remove deplicates. Just identify the fields which can be used to uniquely identify a student (as studentID OR firstname-lastname combination OR something, and use those fields in dedup.
| inputlookup yourlookuptableName.csv | dedup primarykeyfield/primarykeyfieldsSeparatedByComma
You can use dedup command to remove deplicates. Just identify the fields which can be used to uniquely identify a student (as studentID OR firstname-lastname combination OR something, and use those fields in dedup.
| inputlookup yourlookuptableName.csv | dedup primarykeyfield/primarykeyfieldsSeparatedByComma
I got it Dedup function has worked