I want to get a list of all the field names in an oracle.csv file. I generally do something like:
"[inputlookup oracle.csv
| where like(DISTRICT_NAME,"school example%") AND like(DISTRICT_STATE,"TX") AND ACTIVE_STATUS=1 | lookup search_schid2uuid school_id OUTPUT sch_id
| return 50 sch_id]"
Can I just do a wildcard search to get a list of field names?
You could just do this
| inputlookup oracle.csv
| fieldsummary maxvals=10
You might even want to follow that with the fields
command to get rid of the columns that don't interest you.
You could just do this
| inputlookup oracle.csv
| fieldsummary maxvals=10
You might even want to follow that with the fields
command to get rid of the columns that don't interest you.
Worked great thank you