Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!
How to load data from a column when we have multiple rows with in a row.
Output should be:
Please help me on this example.
Then it will retrieve a row with the string "Stevie" (discarding the "J." after the name) and other row with the string "Steve", since I am considering the blank after the name as the field separator...
Hi Noble Raj,
Would it be possible to use a special character to work as "Name delimiter" in your Excel file?
Something, for example a pipe (|) that could set Steven J.|Joseph|Cruz so we could:
LOAD subfield(A, '|' ,1) as Header