stringcsvmatrixpentahokettle
Convert comma separated string/list into table/Matrix format using PDI
Using Pentaho data integration (Kettle), I read a long string from a text file:
a, 1, 2, b, 3, 4, c, 5, 6, ...
Is there any PDI/Kettle steps or method to split this string to become an n column table format like below (the column name can be define freely):
| column1 | column2 | column3 |
|---|---|---|
| a | 1 | 2 |
| b | 3 | 4 |
| c | 5 | 6 |
the above just a simplify example, my real case is having different separator character and the column number (n) is bigger. But I just want to get the main problem solve first.
Solution
I have prepared a SOLUTION for you. In my solution I have set N=3, But you can set as many as you want. Also, you require to input Column name in 'Row denormaliser' step if you want to set N =3/4/5/N.
Although , you can set column name dynamic (if you want) using 'Meta Data Injection' step easily.
- Creating new String with sorted letters from a String word in Java
- Does Python have a string 'contains' substring method?
- JUnit4 TextUtils.isEmpty() gives different result than String.isEmpty()
- c# Fastest way to remove extra white spaces
- Isn't the size of character in Java 2 bytes?
- Alphabetically sorting strings
- How transfer Float number due to HTTP GET request?
- How to fix my conditional string explosions?
- Split a string only on the first of its multiple delimiters to produce a 2-element array
- How to split a comma-separated string?
- Align one string on the left and second one on the right side of textView
- Best way to verify string is empty or null
- Batch add string before filename
- Weird pattern of hybrid radix+quick sort
- Remove equal characters from two python strings
- Is there a way to make this code cleaner without using the strip method?
- Truncate a UTF-8 string to fit a given byte count in PHP
- Shell script - remove enclosing quotes(both single and double) from a value in a key/value pair
- How do you allow spaces to be entered using scanf?
- Is there a generator version of `string.split()` in Python?
- Polars - Replace letter in string with uppercase letter
- Replacing only specific match's group using Java regular expressions by (new Matcher..).replaceAll
- Check if a string is palindrome in C
- How to create variable-sized array of fixed-length "strings" in C?
- Is there a clever way to convert a compex string to multiple lists in Python 3
- Boost::Split using whole string as delimiter
- Collect column range value combined in one cell followed by comma and end with & seperator
- Dollar Sign Character in Multiline Strings
- strip spaces from string using smarty
- How to embed hex values in a lua string literal (i.e. \x equivalent)