Language detection
The transform supports over 70 languages in total. The list of languages supported are:
Afrikaans (af)
Aragonese (an)
Arabic (ar)
Asturian (ast)
Belarusian (be)
Breton (br)
Catalan (ca)
Bulgarian (bg)
Bengali (bn)
Czech (cs)
Welsh (cy)
Danish (da)
German (de)
Greek (el)
English (en)
Spanish (es)
Estonian (et)
Basque (eu)
Persian (fa)
Finnish (fi)
French (fr)
Irish (ga)
Galician (gl)
Gujarati (gu)
Hebrew (he)
Hindi (hi)
Croatian (hr)
Haitian (ht)
Hungarian (hu)
Indonesian (id)
Icelandic (is)
Italian (it)
Japanese (ja)
Khmer (km)
Kannada (kn)
Korean (ko)
Lithuanian (lt)
Latvian (lv)
Macedonian (mk)
Malayalam (ml)
Marathi (mr)
Malay (ms)
Maltese (mt)
Nepali (ne)
Dutch (nl)
Norwegian (no)
Occitan (oc)
Punjabi (pa)
Polish (pl)
Portuguese (pt)
Romanian (ro)
Russian (ru)
Slovak (sk)
Slovene (sl)
Somali (so)
Albanian (sq)
Serbian (sr)
Swedish (sv)
Swahili (sw)
Tamil (ta)
Telugu (te)
Thai (th)
Tagalog (tl)
Turkish (tr)
Ukrainian (uk)
Urdu (ur)
Vietnamese (vi)
Walloon (wa)
Yiddish (yi)
Simplified Chinese (zh-cn)
Traditional Chinese (zh-tw)
To detect languages in a column
1. Right-click the column and select Language detection transform from the context menu.
2. Provide a name to the resultant column in the New column name section.
3. Select the type of output required. As the option name suggests, Language name will render the name of the language as the output, and Language code will render the code of the language.
4. For example, selecting the Language name will give 'English' as the output for an English text , and Language code for an English text will give 'en' as the output.
5. DataPrep shows a live preview of the column during the transform. You can click the Preview button at the bottom of the side panel to preview the output column.
6. You can apply this transform to only one column. Click the Apply button to apply this transform.
To apply filters
- Actual: This option lets you filter rows based on the actual values in the column. Click here to know more.
- Data quality: This option lets you filter rows based on the quality of data in the column. Click here to know more.
- Patterns: This option helps you filter rows based on the data patterns in the selected column. Click here to know more.
- Outliers: This option allows you to filter rows based on the outliers present in the data of the selected column. Click here to know more.
- Using the logical operators, you can combine the conditions and apply logic to determine the rule of precedence. The final expression is displayed in the Criteria expression box. You can click Edit to alter the default expression using logical operators and parenthesis to specify the precedence or the sequential order as to which condition should be evaluated first. Click Save after making the required changes.
- For example, In the expression, ((1 OR 2) AND (3 OR 4)) , at first the condition ( 1 OR 2 ) will be executed and the condition ( 3 OR 4 ) will be executed next. Thirdly, since, the AND operator is used, the filter will be applied when both the conditions are true.
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
|
Quick Links |
Workflow Automation |
Data Collection |
|
|
||
|
Form Templates |
||
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Column Explorer
The Column Explorer in Zoho DataPrep allows you to search, navigate and control the viewing options of the columns in a dataset. You can search and filter columns with invalid or missing data and fix them quickly. This helps you focus on the columns ...Duplicate Column
Zoho DataPrep allows you to duplicate columns present in your dataset. To duplicate columns 1. Right-click on a column header and select the Duplicate columns option from the context menu. 2. Select the columns from the Columns to duplicate dropdown. ...Cluster and merge
Zoho DataPrep helps you to perform fuzzy matching using the Cluster & Merge transform. Using this transform, you can replace multiple versions of the data which are expressed differently with the version required by the user. For example, if the ...Context menu
Zoho DataPrep offers various options in the context menu to perform column level operations. A few basic options here are Sort, Rename, Delete and Move. To access the context menu, right click the column name and click any one of the icons to perform ...Convert units
DataPrep offers special operations to meet unique requirements with transforming data. For example, if you need to share your dataset with different regions which use different standards of measurements, you can use the Convert units special ...