Today, i will discuss about the split fields component usage based on the occurrence of delimiter. In last blog, we encountered that if occurrence of delimiter vary, then the split field component will not work effectively. In other words, alone split field component is sufficient to get the proper results. Please see the below image which demonstrate the dynamically using split field component based on the count of delimiter occurrence. Here, switch/case component and java expression is added. Below is the java script used to get the occurrence of delimiter.…
Day: May 15, 2018
SPLIT FIELDS COMPONENT IN PENTAHO
Today, i will discuss about the “Split Fields” component in Pentaho. Split Fields component split the value of a variable into multiple variables based on delimiter.For example, consider a variable var1 having value a;b;c. Now i need to split into three different values a,b and c. In order to achieve this, use split Fields component in Pentaho with delimiter as “;”. See the below image for the same. Use Generate rows to generate one variable with value “a;b;c”. Then use the split Field component with delimiter as “;”. See the…